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 *~