Replace sql issue

[naidop]

hi,

I am trying to replace certain strings in my mysql database.

I have addresses such as this:

60 W 23rd St, New York 10010 Btwn 5th & 6th Ave

I would like to get rid off all the words starting from New York including the comma before the word "New York". The output should be this

60 W 23rd St

I have other address that are similar like this. They all start with the street address. Just like the example above.

What do I have to do to make this happen ?

I would appreciate for any help on this

thanks

[dickersonka]

Show some effort.

Here's a link to get you started
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index

[varmadba]

Try this update table1 set address=left(address,(locate(',',address) -1))