Like Case Sensitive in MySQL
A much better solution in terms of performance: SELECT …. FROM …. WHERE `concatenated` LIKE BINARY ‘%SearchTerm%’; String comparision is case-sensitive when any of the operands is a binary string. Another alternative is to use COLLATE, SELECT …. FROM …. WHERE `concatenated` like ‘%SearchTerm%’ COLLATE utf8_bin;