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