Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Sep 11 2008 - 09:31:39 CDT
>From: Darryle Steplight [mailto:dsteplightgmail.com]
>Sent: Thursday, September 11, 2008 10:00 AM
>To: Ryan Stille
>Subject: Re: Selecting a column with a regular expression applied to it?
>MySql does have regular expressions. See Link
[JS] But I think regular expressions can only be used as a true/false match
test, not for manipulating data. You can use the REPLACE() function.
>On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille <ryancfwebtools.com>
>> From looking at the MySQL 5 docs, it doesn't look like there is any
>> select a column with a regular expression applied to it?
>> I have a column that has ended up with some non ascii characters in
>> probably vertical tabs and things like that from MS Excel. I need to
>> by this field but its not coming out right because some of the values
>> these bad characters at the beginning. I'd like to select that
>> a regex applied to it that strips out all the non-ascii chars, then
>> that field. Is this possible?
>> All the examples I saw are just using the regex in the where clause.
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartzthe-
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql