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 <siv...@hcl.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. > > > ----------------------------------------------------------------------------------------------------------------------- >