SQL: Update/Set Table Field To All Lowercase

July 10th, 2023





A simulated query for replacing all the content with lowercase.

A simulated query for replacing all the content with lowercase.

Here’s a short snippet that I recently used to remove some camel case records and make them lowercase.

UPDATE `table`
SET field = LOWER(field)

This will set `table`.`field` to all lowercase letters.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *