Mega Code Archive
Lists names from the names table with the longest names first
<![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
-> FROM name
-> ORDER BY LENGTH(CONCAT(first_name,' ',last_name)) DESC;
mysql>
mysql>
mysql> drop table name;
Query OK, 0 rows affected (0.00 sec)
]]>