Scott
> O.K. dumb question. A bigger string can't be contained in a smaller one.
> But how can I make it so someone searching "dogs" can pull up an item that
> contains dog?
My first instinct was to tell you to use perl and a dictionary of common
terms.
But I remembered there is the LIKE functi
HI CRAIG,
i'ts possible to use this query with multiple search terms?
query: "select * from TABLENAME where
if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFIE
LD)
like '%SEARCHTEXT%' "
i.e: one user search for: "passaros jogos campos" [in portugueze]
the app is writt
I don't believe you could do that with a single SQL statement. The best
way would be to build intelligence into an application that would look at
the search term, determine if it is a plural by looking up it some sort of
dictionary, and then use the singular in the form %singularsearchterm%.
O.K. dumb question. A bigger string can't be contained in a smaller one.
But how can I make it so someone searching "dogs" can pull up an item that
contains dog?
Thanks,
SW
On Wednesday 10 April 2002 17:58, you wrote:
> In "MySQL" it says that adding the following to a where clause:
> like "%$s
You are searching for the word "dogs"...that word is not contained in
the word 'dog' or the phrase 'dog house.'
If you searched for '%dog%' you would get both of those results.
The wildcard character allows any other character in it's place...hence
'%dog%' finds 'mydog', 'mydogs', etc, etc...it
