make search word sensitive

[pacuran]

Hi there,
I made my site search like usual. I used 'like' in my database queries:
SELECT * FROM table WHERE body LIKE '%act%'

But users couldn't find what they were looking for because this query returns in the result even rows that contain for example 'actor'. That's why I desided to make my search word sensitive:

SELECT * FROM table WHERE body LIKE '% act %'

It was again not OK because If the word 'act' is in the begining of the sentence or there is any punctoation this row is not between returned results.

Any ideas how I can make my search word sensitive and to filter this potential problems ?

Thanks in advance.

SaS. 🙂)

[[deleted]]

http://www.phpbuilder.com/columns/clay19990421.php3