Help with search engine-type thing

Well, basically what I am wondering, is what code would you use to check if something matches something in a column in a Mysql db. Such as: Lets say someone types "pie" the program runs through the DB and searches for the word "pie" and returns a certain value?

select yourValueColumnName
from yourTableName
where textColumnName like '%pie%'