I think the MySql is not case sensitive for selecting values. for example I am having a table called dept,
Id | Depart
1 | BTECH
11 | it
12 | ibt
2 | BE
21 | cse
22 | ece
Now i want to select the capital dept values from dept, but not using the id. how can i achieve it. I tried the following as query ..
select upper(depart) from dept;
but its just converting all values of dept table to capital. that is
it shows as follows
So how can i filter the lower case values to just display the upper case values to look like the following result
please help me if u know the solution.