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
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 3/10/2006
