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 15-03-2024
115

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