Home Forums SQL Server 2008 SQL Server Newbies parse string and update table in mysql RE: parse string and update table in mysql

  • November 1, 2013 at 10:15 am

    #1663499

    update my_contacts

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

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

    solves the problem!