Searching MySQL database

[terfle]

I'm having problems searching databases using wildcards.

Here is my query:

$result = mysql_query ("SELECT * FROM event WHERE Headline LIKE '%$search%');

This is fine but it picks up word parts, for example when you search "page" it yields "homepage"

So then I changed the query to:

$result = mysql_query (" );

This also has a problem, that it doesn't allow searches after the word in the sentence. Does anyone know an efficient way to query a database and get around these issues?

[terfle]

My second query was:

$result = mysql_query ("SELECT * FROM event WHERE Headline LIKE '$search%');

[terfle]

The difference between the two queries are that there are two '%' wildcards on the first query and just one wildcard on the second one.