Re: case-insensitive select?
| From: | eon | Date: | Tue, 24 Jul 2001 00:43:03 +0000 |
| Subject: | Re: case-insensitive select? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10691@lists.php.net to get a copy of this message | ||
i use ...
SELECT *, UPPER(name) AS testfield FROM testtable ORDER BY testfield
hope it helps.