SELECT * FROM table WHERE keywords LIKE "%tree%";
works great but how can i represent by web those results that are asociated to a filename that is an image.
Let me explain:
table
filename
01.jpg
path
/images/01/
keywords
tree cat house black young
if i do a search of cat the result will give me the result of keywords but i wish to see the result with the image 01.jpg.
anyone knows how to do this?.