>-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 irritatin
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
A simple way is ...
...
WHERE LOCATE('venu', col_name ) > 0
...
or if the column is [VAR]BINARY, LOCATE('venu',CAST(col_name
> -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
> ma
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
pap
