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-]', ''), '-+', '-'));
Create a slug from a name in MySQL/MariaDB
0 min read
28 words
Andrew
Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.
Related Articles
How to Join Multiple MySQL Tables in Python
Aug 9, 2022 • 1 min read
How to Join Multiple MySQL Tables in Python
How to Purge the BinLog for MySQL and MariaDB
Mar 27, 2020 • 1 min read
How to Purge the BinLog for MySQL and MariaDB
How to Delete from a Table where rows match in Another Table – MySQL
Mar 24, 2020 • 0 min read
How to Delete from a Table where rows match in Another Table – MySQL
REPLACE INTO instead of INSERT INTO – MySQL
Mar 23, 2020 • 0 min read
REPLACE INTO instead of INSERT INTO – MySQL
How to Change a MariaDB/MySQL Data Directory to a New Location on Linux
Mar 7, 2023 • 0 min read
How to Change a MariaDB/MySQL Data Directory to a New Location on Linux
Tags
Recent Posts
Macros in Rust: Metaprogramming Made Simple
Apr 5, 2025