Use the CAST( ) function : CAST « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. CAST

Use the CAST( ) function

       
mysql>
mysql> CREATE TABLE textblob_val
    -> (
    ->  tstr    TEXT,   # not case sensitive
    ->  bstr    BLOB    # case sensitive
    -> );
Query OK, 0 rows affected (0.00 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 tstr FROM textblob_val ORDER BY CAST(tstr AS BINARY);
+------+
| tstr |
+------+
| AAA  |
| BBB  |
| aaa  |
| bbb  |
+------+
4 rows 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.Converted a numeric value to the DATE conversion type.
2.Get the date of birth as one alphanumeric value.
3.Cast value to signed integer
4.Cast birthday to char type
5.Cast null to char type
6.Type Conversion (Cast)
7.Assign by calculation