Search in MySQL from PHP

[microbert]

Hi,

I am trying to build a search page that searches MySQL database. I managed to do the search, but I have a small problem when giving the query.

Ex:
 

If for example I am searching for "how to make a search" and I type "make a search" - it works fine but if It type "how to search" it doesn't work.

can someone help me out since I am loosing my mind on this.

my sql command is:

$SQL = mysql_query("SELECT * FROM stocks WHERE `name` LIKE '%$keywords%' order by code");

help is very appreciated

 

[Eiseth]

Because LIKE will search using the whole keyword and not word by word

[Barand]

Have a look at MySQL FULLTEXT searches

[microbert]

But is there a way to search word by word?

[microbert]

My Database id InnoDB and it is not supported with FULLTEXT Search. Is there another way to do this?

[Barand]

WHERE name LIKE '%$word1%' AND name LIKE '%$word2%' AND name LIKE '%$word3%'

[microbert]

To be fair I have tried to explode the keywords into an array and then run a look to make the sql command but it didn't work.

I was hoping there is another way to make this work.

[Barand]

Sphinx supports InnoDB