Posted by David Smithz on 03/01/07 18:32

Ideally another way of doing this would be to use the regular expression in
a replace statement (currenlty playing around with this).

e.g.

SELECT REPLACE (mobile_number, ' ', '') FROM `mytable` WHERE 1 LIMIT 5

the above works in removing the blank spaces, but if I could instead have a
regular expression to say, instead of just spaces, any non numercial
character, this would be good.

[Back to original message]