Received: from newman.hartehanks.com (newman.hartehanks.com [204.89.158.3]) by postgresql.org (Postfix) with ESMTP id 1D34A475AAA; Fri, 15 Mar 2002 12:43:18 -0500 (EST) Received: from linmail.hartehanks.com (linmail.hartehanks.com [172.21.116.31]) by newman.hartehanks.com (8.11.2/8.11.2) with ESMTP id g2FHbjX06193; Fri, 15 Mar 2002 12:37:45 -0500 Subject: Re: case insensitive search To: Jon Hassen Cc: arun kv , PGSQL , pgsql-php-owner@postgresql.org X-Mailer: Lotus Notes Release 5.0.6a January 17, 2001 Message-ID: From: timothy_maguire@hartehanks.com Date: Fri, 15 Mar 2002 12:40:34 -0500 X-MIMETrack: Serialize by Router on linmail/Harte-Hanks(Release 5.0.9 |November 16, 2001) at 03/15/2002 12:40:35 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200203/32 X-Sequence-Number: 1001 I also use the ~* operator for situations like these select * from table where field ~* 'searchterm' and .... Tim. Timothy P. Maguire Web Developer II Harte-Hanks 978 436 3325 Jon Hassen , PGSQL com> Sent by: cc: pgsql-php-owner@pos Subject: Re: case insensitive search tgresql.org 03/15/2002 12:36 PM Have you looked in the manual? Try: 'where ILIKE 'searchword'; At 12:01 PM +0530 3/15/02, arun kv wrote: >hello, > how to do a case insensitive search on postgresql database. i will >enter a keyword in text field and it has to search for that keyword in >keywords field of table and should be case insensitive. > >can i use egrei() function. if so how.here two attributes should be >strings. but first attribute i will get from previous php page and second >attribute is field name of database table. how do i do this. > pls help me > thanking you > Arun > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly HARTE- HANKS PRIVILEGED AND CONFIDENTIAL INFORMATION- if you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein and should delete this message.