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
