I have a field called Photos in a database of information scraped from public records. This field contains the Photo information if one is available, however, if no photo is available, it inserts a Map link instead.

The map link always starts the same, but ends differently. I can search and replace for an exact match, but neither UPDATE or REPLACE seem to be able to handle LIKE strings.

How can I query a MySQL database...