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:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 5:32 AM
> To: Ben Cairns
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
