>-----Original Message----- >From: VenuGopal Papasani [mailto:[EMAIL PROTECTED] >Sent: Monday, March 13, 2006 11:48 >To: Jeff >Subject: Re: Help regarding a simple query > > >Hi Jeff, > This is venu again.Last mail i did not include a constraint that is what irritating me most.Actually if i got venu-kkk > I should not get that venu-kkk. > This was the query actually i want. > > Can you please give me teh query for that > >Regards, >venu. > Please post all responses to the mailing list, not directly to another person.
the "%" is a wild card character Name ---------- Venu VENU XVENU yVeNu Venuzztest select * from X where Name like '%venu%' returns: Venu VENU XVENU yVeNu Venuzztest select * from X where Name like 'venu%' returns: Venu VENU Venuzztest select * from X where Name like '%venu' returns: Venu VENU XVENU yVeNu Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]