RE: [PHP-WIN] Newbie question...
| From: | Mayo, Bill | Date: | Fri, 23 Feb 2001 18:41:26 +0000 |
| Subject: | RE: [PHP-WIN] Newbie question... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5719@lists.php.net to get a copy of this message | ||
You do need to use % instead of *. I think it is because you are going
through an ODBC driver, not because of PHP itself (but I could be wrong).
> -----Original Message-----
> From: Tom Mathews [SMTP:tpm@st.com]
> Sent: Friday, February 23, 2001 5:32 AM
> To: Ben Cairns
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] Newbie question...
>
> don't like being picky, but you may be thinking of MySQL where
> % is the multiple character wildcard (eg select 'David!' LIKE '%D%v%';)
> _ is the single character wildcard (eg select 'David' LIKE 'Davi_';
>
> Tom
>
> Ben Cairns wrote:
>
> > The wildcard in PHP is a %
> >
> > E.G.
> > select * from YOUR_TABLE where SOME_FIELD like '%$dan%'";
> >
> > Hope this helps
> >
> > -- Ben Cairns - Head Of Technical Operations
> > intasept.COM
> > Tel: 01332 365333
> > Fax: 01332 346010
> > E-Mail: BenC@intasept.com
> > Web: http://www.intasept.com
> >
> > "MAKING sense of
> > the INFORMATION
> > TECHNOLOGY age
> > @ WORK......"
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-windows-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net