search (LIKE) within a text field?

[tonyw]

hi all,

i want to search for keywords within text fields. My attempts to use LIKE are testing against the whole text field, and not single words within it?

so, text entry might be - "this is my text"

but this -

$query = "SELECT * from table where text LIKE 'my';

doesnt work.

I must be close? 🙂

[LordShryku]

$query = "SELECT * from table where text LIKE '%my%';

That would work. The % is a wildcard. So it's saying "text like anything before the word me and anything after".