Mysql search 'no' no no. ' or not";

Question

Is there a way I can make mysql be case sensitive using a search where x likes "% #%";

Answer 1

Try the following:

SELECT * FROM <table> WHERE <column> COLLATE latin1_bin LIKE '%No.%'

Answer 2

You can change the type of column:

create table my_table (case_sensitive_column VARCHAR(10)) CHARACTER SET latin1 COLLATE latin1_bin;

EDIT In fact, jwsample's answer is better, because you do not need to modify the table.

Answer 3

http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html

http://aspadvice.com/blogs/ssmith/archive/2007/09/30/Case-Sensitive-or-Insensitive-SQL-Query.aspx