Hi,
update tbl_products set p10_price=mid(p10_price,2) where p10_price regexp ('[^0-9.]');
Which worked because the mucky characters were always the first two digits but it's still cludgy.
What I really wanted to do was just "filter out the good any currency numerics of form \d+.\d\d
10.95 but as mysql only supports regexp when matching,
I reckon a regex_replace would be a great idea... any plan for that feature ?
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
