forgot to cc the list...
# [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700:
> On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700:
> >>On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote:
> >>># [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700:
> >>>>This is not proper syntax, but I would think it is close...
> >>>>select replace(contact_phone, REGEXP "^[1234567890]",'') from
> >>>>individual;
> >>>
> >>> I don't use REs in MySQL, but inverse classes are written [^spec],
> >>> not ^[spec].
> >>
> >>Thanks for the input Roman.
> >
> > did it help? was that your problem?
>
> Actually, although I appreciate your answer, this did not address my
> core need which was to figure out how to use REGEX in MySQL, combined
> with something like the replace function, to alter the output of a
> column in a select statement. My focus was not on the syntax WITHIN the
> REGEX, but rather how to use REGEX to accomplish my goal. Does that
> make sense? If you have further insight, it would be much appreciated!
I've skimmed the manual, and looks like you'll have to do this
outside MySQL. But you probably arrived at that conclusion already.
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
