Select * From (finding a keyword)

I am trying to write a MySQL query which will find a single word (or string of characters) in a column. For example it should be able to find "capital high school" if the query is "high".

The query I've tried is
SELECT * FROM schools WHERE name = 'high';

I know that the % sign is the wildcard character but everytime I try using it the query fails. Can someone show me the EXACT syntax for the query I'm looking for?

------------------
Luke Bowerman
new media arts
http://www.judebowerman.com/nma

SELECT * FROM schools WHERE name LIKE '%high%';

How do you dice up the keyword sting? I'm trying to use php with mySQL?
thanks.