Create a Slug From a Name in MySQL/MariaDB

Published on 25 August 2023

Author: Andrew

Estimated reading time: 1 min

#SQL, #My SQL

How to create a slug from the name of an item in MySQL/MariaDB.

UPDATE my_table
SET slug = LOWER(REGEXP_REPLACE(REPLACE(REPLACE(REPLACE(name, ' ', '-'), 'and', '-'), '[^a-zA-Z0-9-]', ''), '-+', '-'));

Published on 25 August 2023

Filed under #SQL, #My SQL