MySQL multiple keyword search algorithm
I want all of you to write ideas/recommendations to build up a multiple search algorithm.
On my case I'm using PHP, but I want to build up a general algorithm based on your ideas.

Let's take my case: I have products table in my MySQL database. I want to search after multiple keywords in the `title` and `description` columns. 

How should the best (optimal) search work? Don't forget that the keywords can contain multiple words, i.e: "blue electric bosch toaster machine".

So far I was thinking about:
    1. using the LIKE "%$keywords%" in MySQL
    2. spliting the keywords based on whitespaces and search after each of them. BUT: I SHOULD SEARCH AFTER COMBINATIONS OF THEM ALSO. How to do that?

Please share your ideas regarding this algorithm.
Thank you.
MySQL multiple keyword search algorithm
===

I want all of you to write ideas/recommendations to build up a multiple search algorithm.
On my case I'm using PHP, but I want to build up a general algorithm based on your ideas.

Let's take my case: I have products table in my MySQL database. I want to search after multiple keywords in the `title` and `description` columns. 

How should the best (optimal) search work? Don't forget that the keywords can contain multiple words, i.e: "blue electric bosch toaster machine".

So far I was thinking about:
    1. using the LIKE "%$keywords%" in MySQL
    2. spliting the keywords based on whitespaces and search after each of them. BUT: I SHOULD SEARCH AFTER COMBINATIONS OF THEM ALSO. How to do that?

Please share your ideas regarding this algorithm.
Thank you.