I am creating a search form for the TitleName. When I type in one word it finds all titles with the one word. If I use two words it doesn't work. How do I change my select statement to make it work? Thank you.
SELECT * FROM Titles A, ActorTitle B, Actors C WHERE A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%Title%' GROUP BY A.TitleName ASC Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (Name, ActorID) ActorTitle (TitleID, ActorID) TitleGenres (TitleID, GenreID) MYSQL --------------------------------------------------------------------- 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
