Controlling String Case Sensitivity for MIN( ) and MAX( ) : MIN « Aggregate Functions « SQL / MySQL






  1. SQL / MySQL
  2. Aggregate Functions
  3. MIN

Controlling String Case Sensitivity for MIN( ) and MAX( )

       
mysql>
mysql>
mysql> CREATE TABLE textblob_val
    -> (
    ->  tstr    TEXT,   # not case sensitive
    ->  bstr    BLOB    # case sensitive
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql>
mysql> INSERT INTO textblob_val (tstr,bstr) VALUES('aaa','aaa'),
    ->                                            ('AAA','AAA'),
    ->                                            ('bbb','bbb'),
    ->                                            ('BBB','BBB');
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT * FROM textblob_val;
+------+------+
| tstr | bstr |
+------+------+
| aaa  | aaa  |
| AAA  | AAA  |
| bbb  | bbb  |
| BBB  | BBB  |
+------+------+
4 rows in set (0.00 sec)

mysql>
mysql>
mysql> SELECT MIN(tstr), MIN(bstr) FROM textblob_val;
+-----------+-----------+
| MIN(tstr) | MIN(bstr) |
+-----------+-----------+
| aaa       | AAA       |
+-----------+-----------+
1 row in set (0.00 sec)

mysql>
mysql> drop table textblob_val;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.Returns the minimum value from a group of values: MIN()
2.And to find the lowest commission that any of the sales staff is earning, use this:
3.Use MIN( ) or MAX( ) With a GROUP BY clause
4.MIN( ) and MAX( ) also work with expressions or values that are derived from column values.
5.Do calculation with aggregate function
6.What are the lowest and highest U.S. state populations?
7.To make bstr not case sensitive, you can convert the values to a given lettercase:
8.What are the shortest and longest trips in the mytable table?