Hey - -- -

MySQL is the engine. I'm trying to do a SELECT where it retrieves only 
the alpha values in the field, to wit:

in_field   => result set

abc123        abc
wzyt4         wzyt
asdf2345      asdf

MySQL's replace function needs an exact match. There is a REGEXP 
function, but it only seems to return a 1 or 0 if there is a matching 
pattern in the field or not.

Anyone know if this is possible?

Ken

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to