Re: postgres and php
| From: | Nuno Silva | Date: | Sat, 14 Jul 2001 21:32:44 +0000 |
| Subject: | Re: postgres and php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57907@lists.php.net to get a copy of this message | ||
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