List:General Discussion« Previous MessageNext Message »
From:Jeff Date:March 13 2006 3:37pm
Subject:RE: Help regarding a simple query
View as plain text  
> -----Original Message-----
> From: VenuGopal Papasani [mailto:venu.papasani@stripped] 
> Sent: Monday, March 13, 2006 10:33
> To: mysql@stripped
> Subject: Help regarding a simple query
> 
> 
> Hi,
>   I am searching for a query where i can have pattern 
> matching without considering the cases.You can consider the 
> following example for detailed description of what i want exactly.
> 
>    Let my table X consists of following data
>     Name
> -------------------
> venu
> venup
> venugopla
> VenugOpal
> VENU
> papasani
> papasni
> pvenu
>       Now i need to get all the records which consists of the 
> string venu(case should not be considered either case should 
> be).i.e i should get 1,2,3,4,5,8 records
>      I will be very much thankful if any of you give me the 
> query for this.
> 
>      Thanks in Advance,
> 
> Regards,
> venu.
> (sorry for my poor English)
> 

Won't this work?  

Select * from X where name like '%venu%'

jeff


Thread
Help regarding a simple queryVenuGopal Papasani13 Mar
  • RE: Help regarding a simple queryJeff13 Mar
  • Re: Help regarding a simple queryPeter Brawley13 Mar
RE: Help regarding a simple queryJeff13 Mar