MySQL Search Function

[djneel]

Hi all, quick question:

 

I am trying to do build a simple search function for my website. Simply said, the script below gives you a view on what I'm trying to do.

 

SELECT * 
FROM table 
WHERE title, contents, author 
LIKE '%keyword%'
ORDER BY date 
DESC

 

So I tried this:

 

'SELECT *
FROM table
WHERE title
LIKE "%'.$keyword.'%"
OR contents
LIKE "%'.$keyword.'%"
OR author
LIKE "%'.$keyword.'%"
ORDER BY date 
DESC';

 

The script above only produces limited results (most of the time, I only get results when the title matches...). When I replace OR with AND, I get no results...

 

Anyhow, my question is: do I have to make several queries, one for each row? Or is there a way to lookup data in every row with just one query?

 

My MySQL version is: 'MySQL - 5.0.27-standard'

 

Thanks!

 

 

 

 

[fenway]

Well, OR is what you want, I assume the query gets proprely produced... you may want to look at full-text indexing.

[djneel]

Owkay, thank you. I'll figure it out!