Re: how to update row by replacing substitution

[Randy Clamons]

You're using Perl syntax in a mySql query. You might try REPLACE():

"UPDATE tbl SET firstname=REPLACE(firstname,'aaa','') WHERE id=?"