SQL: Cheatsheet

Replace strings

Example: Replace .JPG with .jpg in the media table:

UPDATE media SET file_name = REPLACE(file_name, '.JPG','.jpg');