[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