seriousdamage Posted January 17, 2008 Share Posted January 17, 2008 Hi, when I run the following query I only get the exact match of what I have searched for, I think I need to use % sign so that I can search for Nic and get also Nicola as a result. But I can figuer out where to add the % I use an external webform for the search. $result = mysql_query("SELECT * FROM contacts where first_name LIKE '" . $_POST['search'] ."' OR last_name LIKE '" . $_POST['search'] ."' OR company_name LIKE '" . $_POST['search'] ."' OR website LIKE '" . $_POST['search'] ."' OR street LIKE '" . $_POST['search'] ."' OR city LIKE '" . $_POST['search'] ."' OR zip LIKE '" . $_POST['search'] ."' OR country LIKE '" . $_POST['search'] ."' OR mail1 LIKE '" . $_POST['search'] ."' OR mail2 LIKE '" . $_POST['search'] ."' OR phone LIKE '" . $_POST['search'] ."' OR mobile LIKE '" . $_POST['search'] ."' OR card LIKE '" . $_POST['search'] ."' OR birthday LIKE '" . $_POST['search'] ."'") or die (mysql_errno().": ".mysql_error()."<BR>"); Quote Link to comment https://forums.phpfreaks.com/topic/86480-solved-only-geting-exact-match-from-database-query/ Share on other sites More sharing options...
revraz Posted January 17, 2008 Share Posted January 17, 2008 After LIKE and after the ' Quote Link to comment https://forums.phpfreaks.com/topic/86480-solved-only-geting-exact-match-from-database-query/#findComment-441885 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.