MySQL Searching Entire Tables

What would be a query for searching an entire database for a word or multiple words? Not just searching a single row. For example searching the "pagetitle" and "description" fields from the entire database for the words "clockwork orange".

 

SELECT queries automatically search an entire table for the parameters in the WHERE clause unless you tell it not to by specifying a LIMIT.

 

I'm looking for something like this:

$query="SELECT * FROM vids WHERE desc LIKE '$q' || tags LIKE '$q'";

But that doesn't work.

 

$query="SELECT * FROM vids WHERE desc LIKE '%$q%' OR tags LIKE '%$q%'";