Search engine for mySQL Table, help need

[Anon]

Hi,

I have a mySQL table with 20 text fields, i have design a search engine that works fine when the keyword value has only one word.
It performs a 'like %$keyword%' on each field.

My question is :
what is the best coding way if someone enter a keyword value with several words in it (ex: John Lennon biography) ?
do i need to create a SQL query string with as many 'like' as words ? it means a very very huge query string....

Thx for any help 🙂
Alex

[Anon]

also, another question :

is there any difference in speed when the query browse all fields or just one field :
SELECT * FROM table1;
SELECT id FROM table1;

or is it the same speed ?
thx