How can one ensure that PHP queries consider case sensitivity when using the LIKE operator?

By default, the LIKE operator in PHP is case-insensitive, meaning it will not differentiate between uppercase and lowercase letters when performing a search. To make PHP queries consider case sensitivity when using the LIKE operator, you can use the BINARY keyword to force a case-sensitive comparison. This will ensure that the search is performed with respect to the case of the letters in the query. 

$searchTerm = 'example';
$query = "SELECT * FROM table_name WHERE BINARY column_name LIKE '%$searchTerm%'";
// Execute the query and fetch results

Keywords

PHP LIKE operator case sensitivity COLLATE utf8_bin

Related Questions