can I SELECT entries based on contents of text fields

mysql

[Sarah Atkinson]

I want to select all files whose question field contains the word 'his' can I do this?

[coopster]

I suppose you could loop through your files and execute a LIKE query, processing any results that come back for each iteration of the loop.

[Sarah Atkinson]

jatar sugested something like that and it worked. I'm working with it in php admin so no writing php code here.

Basicly I'm just going though fixing typos. and unfixing sentence structure which I fixed when entering but apperently needs to be broken because state goverment doesn't care aboult correctness just consistancy.