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-]', ''), '-+', '-'));
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-]', ''), '-+', '-'));
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.
Aug 9, 2022 • 1 min read
How to Join Multiple MySQL Tables in Python
Mar 27, 2020 • 1 min read
How to Purge the BinLog for MySQL and MariaDB
Mar 24, 2020 • 0 min read
How to Delete from a Table where rows match in Another Table – MySQL
Mar 23, 2020 • 0 min read
REPLACE INTO instead of INSERT INTO – MySQL
Mar 7, 2023 • 0 min read
How to Change a MariaDB/MySQL Data Directory to a New Location on Linux