Jim Burnett wrote:
> is there a way to use wild cards in a WHERE statement?
> WHERE pet.name = "jim "
> right now i can only use WHERE if i have an exact match, If I am searching a large
> table, can I use WHERE with just part of that data in a specified field? That way it will
> list every record with the word 'jim' it then group it by a speceified name.
WHERE pet.name LIKE "%jim%"
WHERE pet.name LIKE "jim %"
you get the idea.
|• exact matching||Jim Burnett||25 Jun|
| • Re: exact matching||Gerald Clark||25 Jun|