I have a db with slightly over 614,000 records of names and addresses. In the address column, there are quite a few records like
"123 any rd # 2" "319 w. 1st st # B" "4321 test blvd # 42" etc I want to replace all the number signs with the actual word 'number'. Is there a SQL command I can use for this or do I need the help of a scripting language (php or vb)? I was trying to construct something like "update into table.column select where column like '%#%' replace with '%number%'" but of course that is not going to work. I am a SQL newb btw. Any help appreciated. Thanks Scott --------------------------------------------------------------------- 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