Thank you for the link Darryle, but I don't think you read through my
whole question. I have already read through that page, and I see how to
use regex as a condition for a select. What I am interested in is
applying a regex to a column as I select it. Selecting a varchar
column with all the non-ascii characters removed, for example.
-Ryan
Darryle Steplight wrote:
Hi Ryan,
MySql does have regular expressions. See Link
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
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]
