MYSQL REGEXP REPLACE - Proving very difficult...

[iceomnia]

Hi Everyone,

So - I have the following problem - here's my query:

SELECT
	CONCAT('C-', `idcategories`, '-', LOWER(REPLACE(categoryname, categoryname REGEXP '[^a-zA-Z0-9]', '-')), '.html')
AS
	`link`
FROM
	categories

This partially works, I get the following results:

C-4-electronics.html
C-5-audio equipment.html
C-6-home entertainment.html
C-7-photography.html
C-8-portable audio.html
C-9-televisions.html
C-10-amplifiers & receivers.html

But there is a problem. My regexp does not seem to be working.

Could anyone please help?

Is there a reason this does not work, because it looks correct and kind of works!

P.S. I am trying to strip out all none-alpha-numeric chars and replace them with a hyphen "-".

[bradgrafelman]

The forums over at MySQL suggested that regexp replacements in MySQL aren't possible (unless you recompile the MySQL daemon with a user-defined function added). Perhaps you will instead have to prepare the the text using PHP instead of via the query?