Skip site navigation (1) Skip section navigation (2)

Re: RE: Wildcard queries via PHP4

From: Grant <grant(at)conprojan(dot)com(dot)au>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: RE: Wildcard queries via PHP4
Date: 2001-04-08 23:46:26
Message-ID: Pine.LNX.4.21.0104090945020.13844-100000@webster.conprojan.com.au (view raw or flat)
Thread:
Lists: 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 *~


In response to

pgsql-php by date

Next:From: Phil GlatzDate: 2001-04-14 15:39:37
Subject: bound variables with PHP?
Previous:From: Jeff FitzmyersDate: 2001-04-06 23:39:03
Subject: RE: Wildcard queries via PHP4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group