case-insensitive select?
| From: | Synthetic.Rage | Date: | Tue, 10 Oct 2000 17:22:28 +0000 |
| Subject: | case-insensitive select? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3483@lists.php.net to get a copy of this message | ||
Hey Y'all;
I have a VARCHAR field in my MySQL database that I've set with the BINARY
attribute so that I can do a case-sensitive SELECT WHERE. However, I now
want to do an ORDER BY on this field, and I'd like it to be
case-insensitive. Any solution to this, either through a specific SELECT
query, or some routine via PHP after the query has been returned? I'm using
PHP4 and MySQL 3.22.32.
Thanks..