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 does not lop of part of your search word in the effort to find something else. -- Jason On Wed, 2002-04-10 at 17:58, Scott wrote: > In "MySQL" it says that adding the following to a where clause: > like "%$somestring%"; > should select matches that contain $somestring in them anywhere. > However when I use it I find that if e.g. I have an entry "dog" in the > database, if I search for "dogs", it doesn't come up. Also if I search for > "dog house" it doesn't come up. How come? > Thanks, > SW > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php