Scott, Saturday, October 05, 2002, 7:45:16 AM, you wrote: SJ> I have a db with slightly over 614,000 records of names and addresses. In SJ> the address column, there are quite a few records like
SJ> "123 any rd # 2" SJ> "319 w. 1st st # B" SJ> "4321 test blvd # 42" SJ> etc SJ> I want to replace all the number signs with the actual word 'number'. SJ> Is there a SQL command I can use for this or do I need the help of a SJ> scripting language (php or vb)? SJ> I was trying to construct something like "update into table.column select SJ> where column like '%#%' replace with '%number%'" SJ> but of course that is not going to work. I am a SQL newb btw. Take a look at string function REPLACE(): http://www.mysql.com/doc/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php