To make bstr not case sensitive, you can convert the values to a given lettercase: : MIN « Aggregate Functions « SQL / MySQL






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

To make bstr not case sensitive, you can convert the values to a given lettercase:

       
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> SELECT MIN(LOWER(bstr)) FROM textblob_val;
+------------------+
| MIN(LOWER(bstr)) |
+------------------+
| 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.Controlling String Case Sensitivity for MIN( ) and MAX( )
7.What are the lowest and highest U.S. state populations?
8.What are the shortest and longest trips in the mytable table?