Search question - how to get specific
Posted: Fri Jan 17, 2003 12:50 pm
I have a search script on my site now using LIKE with wildcards on either side. The problem is that if someone searches on "APHS" which is a type of film, anything with the word photogrAPHS comes up too.
Obviously because the pattern matches. However if I take off the wildcards it wont find it because its not the first word of the string.
Anyone have anything thoughts on how to go about that? So that if you search on APHS is searches the whole field to see if there is a word match?
thanks!
Obviously because the pattern matches. However if I take off the wildcards it wont find it because its not the first word of the string.
Anyone have anything thoughts on how to go about that? So that if you search on APHS is searches the whole field to see if there is a word match?
thanks!