Re: case insensitive search

From: Gurudutt <guru(at)indvalley(dot)com>
To: arun kv <arun(at)library(dot)iisc(dot)ernet(dot)in>
Cc: PGSQL <pgsql-php(at)postgresql(dot)org>
Subject: Re: case insensitive search
Date: 2002-03-15 06:24:44
Message-ID: 89063021.20020315115444@indvalley.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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(at)indvalley(dot)com

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

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message arun kv 2002-03-15 06:31:27 case insensitive search
Previous Message Gurudutt 2002-03-15 04:18:51 Re: Graphics