Using functions in SELECT statements
| From: | Robin S McKenzie | Date: | Thu, 02 May 2002 13:34:02 +0000 |
| Subject: | Using functions in SELECT statements | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18944@lists.php.net to get a copy of this message | ||
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
________________________________