select [A-Z]|[a-z]|[0-9] characters from a table field

[imranlink]

Hi,

I want to write a select query in such a way that should return only [A-Z]|[a-z]|[0-9] character from a table field and disgard other character from it.

For example the table products

part_numbers

MP-97
987/plt543-009
bbbPPP trww\d2_99

will return

MP97
987plt543009
bbbPPPtrwwd299

the result should have no space,dashes,slases. Result only have [A-Z]|[a-z]|[0-9] character.
Please help me to write such query in mysql. I should be much thankfull.

[tomhath]

I don't know of an easy way to do it in SQL.

The best solution would be to use PHP preg_replace function. It's a lot to learn but worth spending the time:

http://us2.php.net/manual/en/function.preg-replace.php