Articles:

• Compare 2 dates in mysql (173)
• mysql: How can I rename a database (121)
• Implementing a full text search with mysql (98)
• How can I rename table names and column names in mysql (96)
• How can I obtain the next auto_increment number (before inserting a record)? (90)
• How to reset the root password on mysql (90)
• Creating a table with an autoincrement primary key (82)
• How to compare strings in mysql case sensitive (76)
• What is the MERGE statement good for? (72)
• Handling of dates in mysql (Date formats) (71)
• Kill a long running blocking sql statement (70)
• Lock an entire mysql database with all its tables (69)
• Best operating system settings for mysql throughput (68)
• Modifying a field to be auto_increment (68)
• How to change the next value of an auto_increment field (64)
• Restoring the mysql system user table (62)
• How to limit the size of a MySQL database (61)
• Setting a user password in mysql (Why do I get 'Access denied') (60)
• Can I install MySQL without root access? (60)
• Extracting a table definition from the command line (57)
• My timestamp field in mysql does not update (57)
• How can I connect to mysql? I need to update the helpdesk backend (50)
• Create UNIQUE Index yields a not unique index in mysql - why? (30)
• Exporting and importing between 2 mysql databases (22)

How to compare strings in mysql case sensitive Question: My application includes a query where I want to list all products with a name that starts in upper case. The SQL looked like .. where prod_name >= 'A' and prod_name <= 'Z'; Turns out this included lowercase products. A further investigation shows select 'A' = 'a'; returns TRUE (1). How can I make mysql case sensitive? Answer: Instead of using the = operator, you may want to use LIKE or LIKE BINARY // this returns 1 (true) select 'A' like 'a' // this returns 0 (false) select 'A' like binary 'a'