Tag Archives: MySQL

Dear MySQL

Posted on by
Reply

Dear MySQL, thanks for your limited regular expression support:

SELECT
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(name, '2006', ''), '2007', ''), '2008', ''), ' ', ''), '/', ''), '.', ''), '\'', ''), '!', ''), '&', '') AS name,
    description
FROM courses;

(Of course I forget to not look a gift horse in the mouth ; )