Searching database with 2 or more keywords?

[Solarpitch]

Hey,

 

I am currently using the below basic sql to search a table in MySql database. It works fin when there is one keyword for example "pine" but if two keywords are entered it returns noting ... eg "pine oak". What would I need to do to get it to work if 2 or more works were entered?

 

<?php

$sql = "SELECT * FROM products where product_name LIKE '%$keyword%' ";

?>

[DarkWater]

Check out FULLTEXT indexes.

[lemmin]

Check both criteria:

<?php

$sql = "SELECT * FROM products where product_name LIKE '%$keyword%'  AND product_name LIKE '%$keyword2%'";

?>

[DarkWater]

1) You'd probably use OR.

 

2) That gets a little inefficient after a while.