REGEXP in replace()?

[Piet Wesselman]

I have a field where I want to remove non-alphanumeric characters at the 
end of the field. I thought of using a query like:

UPDATE table SET field=REPLACE(field, ".", "") where ....

It does not seem possible to use regexes inside the replace() function.
I have two questions on possible improvements of this query:
1. Can I expand the from_str (second parameter) in replace() to the 
collection of non-alphanumeric characters?

2. How can I ensure that only non-alphanumeric characters at the end of the 
string are removed, and not those at earlier positions in the string.

Maybe someone has a imple solution?
Thanks for any help,
Piet Wesselman

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]