Posted by Dave Fountain on 03/04/07 09:43

On Sun, 04 Mar 2007 09:36:52 +0000, Dave Fountain
<daveatdaveandsalcouk> wrote:

>On Thu, 01 Mar 2007 18:32:16 GMT, "David Smithz"
><dave1900@blueyonder.co.uk> wrote:
>
>>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.
>>
>I know nothing about the topic but is there a function that allows you
>to *keep* numerical characters, then you would only have to check for
>10 cases?
Scrap that idea - I saw you could have non-telephone numbers in the
field, but you could also have problems if they wrote something like:
ring after 9 07777 33333 if you just remove the spaces.

• Next in forum: NULL fields in table - efficiency question
• 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]