exact words in a query
Posted: Thu Jun 12, 2003 5:08 pm
I currently have a table set up with a field for keywords extracted from some images, all the keywords are stored in a signle field called keywords (suprise).
Now I need to search through that field looking for exact words that a client will be able to type in.
id
client types in mountian
I want to search through the keyword field to see if the word mountian is in there.
Any ideas on how to best approach this?
Or would it be better to store every keyword seperately with the picId attached?
phpScott
Now I need to search through that field looking for exact words that a client will be able to type in.
id
client types in mountian
I want to search through the keyword field to see if the word mountian is in there.
Any ideas on how to best approach this?
Or would it be better to store every keyword seperately with the picId attached?
phpScott