hi there!

the operators you want are ~ and ~* and !~ and !~*.
select name from table where name ~* 'test';

to see all operators availlable type \do in psql's interactive mode ;)

Nuno Silva

Derek wrote:

> anyone know how I force a case insensitive search through a postgres
> database.
> I've got a search looking for 'something like '%something%' but this won't
> find 'SOMETHING'...if you know what I mean!?
> Thanks in advance for any help
> Derek

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to