Jason Chu wrote:
At that point the query would take about the same amount of time and userids can stay in different cases.
In MySQL the default seems to be to have case insensitive matches ( not sure about other databases ), so in this case you wouldn't need the 'lower' function. I have tested my dbmail installation ( on a test box at the moment ), and mine is doing case insensitive matches:
mysql> select user_idnr, userid from dbmail_users where userid = 'DKASAK'; +-----------+--------+ | user_idnr | userid | +-----------+--------+ | 3 | dkasak | +-----------+--------+ 1 row in set (0.00 sec) mysql> select user_idnr, userid from dbmail_users where userid = 'dkasak'; +-----------+--------+ | user_idnr | userid | +-----------+--------+ | 3 | dkasak | +-----------+--------+ 1 row in set (0.00 sec) mysql> -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
