> -----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
> 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
> 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,
> (sorry for my poor English)
Won't this work?
Select * from X where name like '%venu%'