Mega Code Archive
Refer to the additional output column by position
<![CDATA[
mysql>
mysql>
mysql> CREATE TABLE name
-> (
-> last_name CHAR(20),
-> first_name CHAR(20)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> INSERT INTO name (first_name,last_name) VALUES('Kevin','Brown');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO name (first_name,last_name) VALUES('Vida','Blue');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO name (first_name,last_name) VALUES('Pete','Gray');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO name (first_name,last_name) VALUES('Devon','White');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO name (first_name,last_name) VALUES('Rondell','White');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> SELECT * FROM name;
+-----------+------------+
| last_name | first_name |
+-----------+------------+
| Brown | Kevin |
| Blue | Vida |
| Gray | Pete |
| White | Devon |
| White | Rondell |
+-----------+------------+
5 rows in set (0.00 sec)
mysql>
mysql>
mysql> SELECT CONCAT(first_name,' ',last_name) AS name,
-> LENGTH(CONCAT(first_name,' ',last_name)) AS len
-> FROM name
-> ORDER BY 2 DESC;
+---------------+------+
| name | len |
+---------------+------+
| Rondell White | 13 |
| Kevin Brown | 11 |
| Devon White | 11 |
| Vida Blue | 9 |
| Pete Gray | 9 |
+---------------+------+
5 rows in set (0.00 sec)
mysql>
mysql> drop table name;
Query OK, 0 rows affected (0.00 sec)
mysql>
]]>