title: mysql: remove text from column that is contained in another column
body: <p>So ihave a database that contains address, city, state, and zipcode columns. The problem is the address column includes the address as well as the city, state, and zip. As these are already columns, i dont want them in the address column. Is there a way to dynamically remove the data from the address column that matches city, state, and zip? The database has over 50,000 rows.</p>