Re: Return REG Value

2005-06-21 Thread Gleb Paharenko
Hello. Probably there is a solution for your task. But for a pity MySQL supports REGEXP only for comparison and nothing more. A sad joke is that issues about phone numbers and regexps regularly appear in the list, sometimes without any answer. However search in archives at: http://lists.my

Return REG Value

2005-06-20 Thread Eric Jensen
Is there a way to return a value that has been modified via regular expressions? For example, let's say I have a bunch of phone numbers. Some of them were entered in like "(123) 456-7890" and some where entered in (123-456-7890". I would like to only pull out the numbers from these fields. I've