i am doing a search function, where the keyword from user can be anything from any column/row. but i have no idea what sql statement should i put at the part marked xxx

SELECT * FROM tablename WHERE xxx LIKE '$keyword%';

i'm am total newbie

__________________
i\'m am total newbie

You should read up on MySQL fulltext searching.

Look at this:
http://dev.mysql.com/doc/mysql/en/fulltext-search.html

Cheers

--
Please contact me at:
Colin (dot) Horne (at) gmail (dot) com
My blog: http://colinhorne.blogspot.com