How does MySQL image name array match the image path field of the table

CSDN Q & A 2022-02-13 05:11:24 阅读数:827

mysql image array match image

Scenario as follows ：
Known array str=["a.png","b.png","c.png",d.png]
The table fields are as follows
id urlPath
1 "img/a.png"
2 "img/b.png"
3 "img/abc.png"
1、 The result is , I want to compete c.png、 and d.png These two documents are not in the table . One sql sentence Table name ：imgTable
I hope some great God can help me see .sql How to write .

Take the answer ：

SELECT * FROM imgTable where right(urlPath, 4) not in (str)