I have also done such a search engine and in my case the LIKE clause works great:
//return all entries with $keyword
TableName LIKE '%$keyword%'
//return all entries starting with $keyword
TableName LIKE '$keyword%'
//return all entries ending with $keyword
TableName LIKE '%$keyword'