>-----Original Message----- >From: Darryle Steplight [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 11, 2008 10:00 AM >To: Ryan Stille >Cc: mysql@lists.mysql.com >Subject: Re: Selecting a column with a regular expression applied to it? > >Hi Ryan, > >MySql does have regular expressions. See Link >http://dev.mysql.com/doc/refman/5.0/en/regexp.html > [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 <[EMAIL PROTECTED]> >wrote: >> From looking at the MySQL 5 docs, it doesn't look like there is any >way to >> select a column with a regular expression applied to it? >> >> I have a column that has ended up with some non ascii characters in >it, >> probably vertical tabs and things like that from MS Excel. I need to >sort >> by this field but its not coming out right because some of the values >have >> these bad characters at the beginning. I'd like to select that >column with >> a regex applied to it that strips out all the non-ascii chars, then >sort by >> that field. Is this possible? >> >> All the examples I saw are just using the regex in the where clause. >> >> Thanks, >> -Ryan >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] >> >> > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
