      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 CHAR)) for case insensitivity.

PB

-----

VenuGopal Papasani wrote:

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)


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 3/10/2006