Created a site that uses a db to store a list of links (www.ihaswebsite.com/downloads/index.php if you want to see what i'm talking about). The search i have now works fine for single words or exact matches with multiple words, but what i want it to do is: * if the user types in: a b result would be anything with 'a' and anything with 'b' however, if they type in "300 dvd", i dont want anything with 300 and anything with dvd (because a lot of things might have 'dvd') but if the title in the db is '300 movie dvd rip', a query of "300 dvd" would be fine. Pretty much, i want to search for a db entry that contains each specified word. The code i currently have is: Code: $query = trim($_POST['searchquery']); /* post query from search box */ $result = mysql_query("SELECT * FROM `downloads` WHERE `Name` LIKE '%" . $query . "%' ORDER BY 'Name'") or die(mysql_error()); /* return results */ anybody know what i should do to get the desired effect?