MySQL case-sensitive LIKE search
When searching for partial strings in MySQL with LIKE you will match case-insensitive by default*.
Databases
SQL: Get the count of related records
Micro tutorial: SQL select the count of related records and sort by it.