RE: [PHP-DB] get first letter from field
| From: | John W. Holmes | Date: | Sun, 04 May 2003 20:13:23 +0000 |
| Subject: | RE: [PHP-DB] get first letter from field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27514@lists.php.net to get a copy of this message | ||
> what can i do when i want to be case sensetive
>
> thanks
>
> "Heilo" <grillen@abendstille.at> wrote in message
> news:BADAFFB3.29A2%grillen@abendstille.at...
> hi!
>
> SELECT
customer FROM
> customerList WHERE customer LIKE
> "A%"
Try:
SELECT customer FROM customerList WHERE BINARY LEFT(column,1) = 'a'
BINARY will make the comparison case sensitive. Should be able to use
the same method with LIKE if you're using that instead of LEFT.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/