Update all values of a column to lowercase

Lets say I have something like this uid tag 1 HeLLo 2 heLLO 3 HELLO 4 hello How can I update all values in the "tag" column to: uid tag 1 hello 2 hello 3 hello 4 hello using MySQL?

Ankur Rajput

Asked 03-12-2024

126

Answer (1)

see here. UPDATE tableName SET tag = LOWER(tag); fully workable; see also; https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_lower

Deepak Sharma

Asked 10-11-2019

45 Likes

Comments

Write comment

Submit your answer