Re: Using functions in SELECT statements
| From: | Robin S McKenzie | Date: | Thu, 02 May 2002 14:11:20 +0000 |
| Subject: | Re: Using functions in SELECT statements | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18946@lists.php.net to get a copy of this message | ||
If only it were that simple - sorry, that was a copying error...
It gives the error " undefined function: lower"
R
Robin McKenzie Department of Mechanical Engineering University of Bristol
e:Robin.McKenzie.98@bris.ac.uk e:robin@finevinyl.co.uk m:+44(0)7970 058712
________________________________
"Peter Lovatt" <pjln1@sunmaia.net> wrote in message
news:NFBBKAGAILLHPFOOAKFIMEDKDHAA.pjln1@sunmaia.net...
>
>
>
> Could it be the second $ in the lower('%$SearchBox$%') ?
>
> Peter
>
>
>
> -----------------------------------------------
> Excellence in internet and open source software
> -----------------------------------------------
> Sunmaia
> www.sunmaia.net
> info@sunmaia.net
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: Robin S McKenzie [mailto:Robin.McKenzie.98@bristol.ac.uk]
> > Sent: 02 May 2002 14:34
> > To: php-db@lists.php.net
> > Subject: [PHP-DB] Using functions in SELECT statements
> >
> >
> >
> > I'm trying perform a case-insensitive test for a name. These are stored
> > like "Association of ...", and I want to convert both the filter and the
> > test data to lower- (or upper-) case. Why doesn't this work: ?
> >
> > SELECT *
> > FROM [Organisation Membership]
> > WHERE lower(organisation) LIKE lower('%$SearchBox$%')
> >
> > Robin McKenzie
> > Department of Mechanical Engineering
> > University of Bristol
> > e:Robin.McKenzie.98@bris.ac.uk
> > e:robin@finevinyl.co.uk
> > m:+44(0)7970 058712
> > ________________________________
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >