List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 25 1999 4:07pm
Subject:Re: exact matching
View as plain text  
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.
> 
> -jim-
WHERE pet.name LIKE "%jim%" 

or possibly

WHERE pet.name LIKE "jim %"

you get the idea.
Thread
exact matchingJim Burnett25 Jun
  • Re: exact matchingGerald Clark25 Jun