PHP MySQL statements WHERE name OR section LIKE %this%

[scrubbicus]

I'm trying to make a quick search that searches all the fields within a table with LIKE statement. How might I go about doing that? I was trying this:

 

I have two fields called lecture and book and I want to search in that for the word man so I made something like this

 

SELECT * FROM table WHERE lecture OR book LIKE %man%

 

But it gave me no results at all when man was present in both fields for much of the information in there

[ToonMariner]

SELECT * FROM table WHERE lecture LIKE '%man%' OR book LIKE '%man%'