Comparison of two strings in sql

Question

I have written an ajax function to check if a value exists inside the database.

For example consider two strings "Book" and "book". In my current situation "Book" is there inside the Database and if I search using the query below

Select * from Cat where name='book'

OR

Select * from Cat where name like 'book'

It returns an empty result set since the 'b' is in lowercase. My collation is utf8_bin. What will be the query to evaluate in such a way that it will be the same whether it is upper case or lower case.

possible duplicate of [What effects does using a binary collation have?](http://stackoverflow.com/questions/5526334/what-effects-does-using-a-binary-collation-have) — Michael - sqlbot, Oct 14 '14 at 11:07

score 1 · Accepted Answer · answered Oct 14 '14 at 07:10

1

Use upper() function to make both strings to upper case:

Select * from Cat where upper(name)=upper('book')

answered Oct 14 '14 at 07:10

Jens

67,715
15
98
113

score 0 · Answer 2 · answered Oct 14 '14 at 07:10

0

If I understand correctly you can use the upper or lower function in the comparison

answered Oct 14 '14 at 07:10

Fusi123

77
1
6

score 0 · Answer 3 · answered Oct 14 '14 at 07:12

0

Use LIKE instead =

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html

Or also convert everythiing to upper/lower before comparing

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_upper

answered Oct 14 '14 at 07:12

Juan

588
1
8
25

I have told in the question that I tried like also. – Manesh Oct 14 '14 at 07:15

Comparison of two strings in sql

3 Answers3