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 ;)
Regards,
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]
