Hi, I have questions on string comparison:
Table: user_att +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | user_id | int(11) | | PRI | 0 | | | att_id | int(11) | | PRI | 0 | | | value | varchar(200) | | | | | | date | datetime | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ - one unique index on user_id and att_id (pk) - one index on att_id and user_id. SELECT * FROM user_att WHERE att_id = 123 and value = 'SANDY'; SELECT * FROM user_att WHERE att_id = 123 and value = 'sandy'; SELECT * FROM user_att WHERE att_id = 123 and value like 'sandy'; The first 2 queries are faster. They result are all the same. However, if I want to retrieve only 'sandy' instead of 'Sandy'. Is there any query to achieve that? Is there anyway to configure mysql to be case sensitive? Thanks! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
