> -----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
