Postgres Pro
Downloads
Home   >   mailing lists

Re: case insensitive search - Mailing list pgsql-php

From Gurudutt
Subject Re: case insensitive search
Date
Msg-id 89063021.20020315115444@indvalley.com
Whole thread Raw
In response to case insensitive search  (arun kv <arun@library.iisc.ernet.in>)
Responses Re: case insensitive search  (knut.suebert@web.de)
List pgsql-php
Tree view 
Hello arun,

ak>         how to do a case insensitive search on postgresql database. i will
ak> enter a keyword in text field and it has to search for that keyword in
ak> keywords field of table and should be case insensitive.

why don't you use "ilike" to search for the pattern in the database.

--
Best regards,
 Gurudutt                            mailto:guru@indvalley.com

Life is not fair - get used to it.
Bill Gates

pgsql-php by date:

Previous
From: arun kv
Date:
Subject: case insensitive search
Next
From: "Papp, Gyozo"
Date:
Subject: Re: Graphics