Re: [PHP] postgres and php

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.

[PHP] postgres and php

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