how do I mark a question as solved?

update my_contacts

set city = substring_index(location, ',', 1),

state = substring_index(location, ',',-1) ;

solves the problem!

there is a substring_index function in MySQL, what is interesting is when I tried your code I get a syntax err msg stating "unknown column city in field list" and...