84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
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%"
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,'%','\%'),'_','\_'), '%'), '%')
SELECT Id, Url, ModelId WHERE Url LIKE CONCAT('%', ModelId, '%')
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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,'%','\%'),'_','\_'), '%'), '%')SELECT Id, Url, ModelId WHERE Url LIKE CONCAT('%', ModelId, '%')