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.

• Next in forum: Re: Regular expression in MySQL (need to strip number fiel of spaces and then match).
• Prev in forum: Re: Regular expression in MySQL (need to strip number fiel of spaces and then match).
• Thread view: Re: Regular expression in MySQL (need to strip number fiel of spaces and then match).

[Reply to this message]