sql: search multiple keywords for one image.
halo there, i need a help on this sql condition. i m doing the searching for multiple keywords.
ok, let say user input keywords : one two three to search an image.(exactly words)
in the database, there is an image with the keywords : one, two.
hmm..may i know how to query it out for one time only? mean..even this image have two match keywords, but it only can display out one time in the search result. can someone plz guide me? i duno how to query it out. plz help.thank you.