Performing MySQL query with case sensitivity

Let us take note of the following example data.

WEBSITE_NAME

dev-notes.com

Dev-Notes.com

DEV-NOTES.com

Note that the first row is in all lower case, the second in proper case, and the third contains all capitalized letters. If we run a normal MySQL select statement to search for “dev-notes” such as the below, the system will return all three records.