Re: RE: Wildcard queries via PHP4 - Mailing list pgsql-php

As far as I know "LIKE" is case sensitive, where as ~* is regular
expression matching and is case insensitive.

On Fri, 6 Apr 2001, Jeff Fitzmyers wrote:

> This works for me on 7.1 beta 6; php-4.0.4pl1
>
> $sql="SELECT *
>  FROM customer
>  WHERE $look_in ~*'$text' AND
>   mbewbe='$mbewbe' AND
>   c_state $query_location
>  ORDER BY company_name;";
>
> jeff fitzmyers
> >>>>
>
> For whatever reason the *~ matching does not work in PHP4 (ie surname *~