[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Using functions in SELECT statements
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:[EMAIL PROTECTED]
is is of some help to you
Tony James
- Original Message -
From: "Robin S McKenzie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 3:11 PM
Subject: Re: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that wa
McKenzie [mailto:[EMAIL PROTECTED]]
> > Sent: 02 May 2002 14:34
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Using functions in SELECT statements
> >
> >
> >
> > I'm trying perform a case-insensitive test for a name. These are stored
> > like
1-242-1473
---
> -Original Message-
> From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2002 14:34
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Using functions in SELECT statements
>
>
>
> I'm trying perform a case-inse
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('%$Sear
