MySQL order by multiple columns

Question

I have a MySQL table like the one below with more information in cells to the right. each row has either a last name or an organisation name.

| lastName | organisationName |

| Smith-----|------------------------|

|-------------| Treehouse ---------|

| Greg------|------------------------|

|-------------| Ally's ----------------|

what I want to do is select everything from the table and order each row by the last name and organisation name so that is is displayed like this.

I've been using SELECT * FROM table_name ORDER BY

but I'm struggling with what to order it by.

Answer 1 · 2014-11-14T03:01:59Z

November 14, 2014 3:01am

The answer would be to do a query in a way that both the columns are merged into a single column and then that column is sorted. Something like

SELECT (lastName || '  '|| organizationName) FROM table_name

OR

SELECT CONCAT(lastName," ",organizationName) FROM table_name

Answer 2 · 2014-11-12T03:14:02Z

November 12, 2014 3:14am

Perhaps try this

SELECT * FROM table_name 
ORDER BY lastName, organizationName

This orders by last name first and then organization name.

However it'll output like this

| lastName | organizationName |

| Greg-----|------------------------|

|-------------| Ally's ---------|

| Smith------|------------------------|

|-------------| Treehouse ----------------|

Welcome to the Treehouse Community