[thelist] mysql query - replacing characters

r937 rudy at r937.com
Tue Aug 4 04:59:56 CDT 2009


> is there a better way to write this query?

no

there is an alternate strategy, which is to store a sanitized value in an 
additional column alongside street_num and street_name, that already has the 
characters removed, which you would do when adding the row, using proper 
regex in your application language

> And if not, why won't it accept more nested replace statements?

it will

please show the query that produced the error


rudy





More information about the thelist mailing list