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 "%$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
