I have a query where I want to search for fields that ends with no.jpg
I have a table where some have file/no.jpg and some fields where it's only no.jpg
Now I would like to look for all that ends with no.jpg to find the fields where an image isn't added yet.
This almost what it looks like now, but I need help with how to write it correct.
SELECT * FROM table_img WHERE table_img.pic = 'file/no.jpg'