Mega Code Archive
Display the composite names, but refer to the constituent values in the ORDER BY clause
<![CDATA[
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 full_name
-> FROM name
-> ORDER BY last_name, first_name;
+---------------+
| full_name |
+---------------+
| Vida Blue |
| Kevin Brown |
| Pete Gray |
| Devon White |
| Rondell White |
+---------------+
5 rows in set (0.00 sec)
mysql>
mysql> drop table name;
Query OK, 0 rows affected (0.00 sec)
]]>