> -----Original Message----- > From: VenuGopal Papasani [mailto:[EMAIL PROTECTED] > Sent: Monday, March 13, 2006 10:33 > To: mysql@lists.mysql.com > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
