MySQL uses another field for fuzzy query

Question

I have a table with two string columns: Url and ModelId. I need to return those records whose URL contains ModelId, similar to this query:

SELECT Id, Url, ModelId WHERE Url like "%ModelId%"

Answer 1

You can't just concatenate strings, you must also escape the fields, using the special characters % and _:

SELECT Id, Url, ModelId 
WHERE Url LIKE CONCAT('%', REPLACE(REPLACE(ModelId,'%','\%'),'_','\_'), '%'), '%')

Answer 2

SELECT Id, Url, ModelId 
WHERE Url LIKE CONCAT('%', ModelId, '%')