I am searching for a string like Cityname, State in mysql table where state name is 2 letter char. - by subson I am searching for a string like Cityname, State (e.g.Moline,IL) in mysql table. How can i make the query using regexp in mysql. Read the article