Re: Help needed in Search

Siva,

in addition to what others said, please note that underscore matches any
character. to change it use escape char.

http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE

2011/9/28 Siva Palanisamy <siva_p(at)hcl(dot)com>

> Hi All,****
>
> ** **
>
> I am trying to retrieve the contact names based on the keyed search string.
> It performs good for the English alphabets and behaves strangely for special
> chars such as _,/,\,%****
>
> ** **
>
> My query in the function is similar to ****
>
> ** **
>
> SELECT contact_name FROM contacts WHERE LOWER(contact_name) LIKE
> LOWER('_McDonald%') ORDER BY LOWER(contact_name) ASC LIMIT 1;****
>
> ** **
>
> It looks like, during searching, it retrieves all the contact names instead
> of the desired. The similar bizarre happens for the above mentioned special
> chars. I need to support these. How do I educate postgres to consider these
> chars? Please guide me.****
>
> ** **
>
> Thanks and Regards,****
>
> Siva.****
>
> ------------------------------
> ::DISCLAIMER::
>
> -----------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> It shall not attach any liability on the originator or HCL or its
> affiliates. Any views or opinions presented in
> this email are solely those of the author and may not necessarily reflect
> the opinions of HCL or its affiliates.
> Any form of reproduction, dissemination, copying, disclosure, modification,
> distribution and / or publication of
> this message without the prior written consent of the author of this e-mail
> is strictly prohibited. If you have
> received this email in error please delete it and notify the sender
> immediately. Before opening any mail and
> attachments please check them for viruses and defect.
>
>
> -----------------------------------------------------------------------------------------------------------------------
>