FW: [PHP-DB] Using functions in SELECT statements
| From: | Peter Lovatt | Date: | Thu, 02 May 2002 14:03:02 +0000 |
| Subject: | FW: [PHP-DB] Using functions in SELECT statements | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18945@lists.php.net to get a copy of this message | ||
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
>