MySQL LOWER() converts all the characters in a string to lowercase characters.
[code lang=”php”]UPDATE `articles` SET `slug` = LOWER(`slug`)[/code]
Month: June 2018
MySQL replace all whitespaces with dash
[code lang=”php”]UPDATE `articles` SET `slug` = REPLACE( `slug`, ‘ ‘, ‘-‘ )[/code]