[Resolved] match an exact word using SQL LIKE

[bgneuschafer]

How would I retrieve records that have fields containing an exact word as opposed to part of a word? Because if I want to find someone's name in a description, say "Tim", I could use the SQL words WHERE Description LIKE '%Tim%' . However, I retrieve records that have the word such as "Time". Without the percentage symbols, the entire field would have to match, correct?

[devinemke]

SELECT * FROM table WHERE Description LIKE 'Tim %' OR Description LIKE '% Tim %' OR Description LIKE '% Tim'

[LordShryku]

Or use strcmp or regex.
http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html

[bgneuschafer]

That worked! Thank you! The percentage sign, then a space, now why didn't I think of that :p