A MySQL user defined function called slugify() that takes in a string like “John’s a great guy” and convert it to “johns-a-great-guy”

slugify.sql

DELIMITER //

CREATE FUNCTION slugify(input_text VARCHAR(255))
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
 DECLARE output_text VARCHAR(255);
 
 SET output_text = LOWER(input_text);
 SET output_text = REPLACE(output_text," ","-");
 SET output_text = REPLACE(output_text,"'","");
 SET output_text = REPLACE(output_text,"’","");
 SET output_text = REPLACE(output_text,"’","");
 SET output_text = REPLACE(output_text,"’","");
 SET output_text = REPLACE(output_text,"’","");
 SET output_text = REPLACE(output_text,"’","");
 SET output_text = REPLACE(output_text,"‘","");
 SET output_text = REPLACE(output_text,"(","");
 SET output_text = REPLACE(output_text,")","");
 SET output_text = REPLACE(output_text,"[","");
 SET output_text = REPLACE(output_text,"]","");
 SET output_text = REPLACE(output_text,"{","");
 SET output_text = REPLACE(output_text,"}","");
 SET output_text = REPLACE(output_text,"<","");
 SET output_text = REPLACE(output_text,">","");
 SET output_text = REPLACE(output_text,"&","");
 SET output_text = REPLACE(output_text,"\"","");
 SET output_text = REPLACE(output_text,"’","");
 
 RETURN output_text;
END //

DELIMITER ; 

To use this function, you can execute the following command: 

SELECT slugify("John's a great guy"); 

This will output: johns-a-great-guy