While creating a table I often need to order it by more than one column. e.g. name and first name, or position and name, ...

Is there a possibility to create a table with more than one order criteria? Often I order by a help column which is not visible, Thus the manual sorting for with more than one column does not work.

Hi Bogdan,

there are two alternatives:

1. While creating a table it would be helpful to generate it with a SQL like e.g.:

SELECT * FROM wp_example ORDER BY Name, FirstName, ...

2. Allow to sort not only one column in specified order like it is right now in the process after creating the table.

This is why I ask for it. You have in a table four Millers:

Miller, Anton
Miller, Charly
Miller, Fred
Miller, William

I need those persons in alphabetical order as it is shown above. But when William was entered first he will be on the top of the list. Of course I can add an additional column with a combination of Name and FirstName. But this is not the most elegant solution as there might be examples with more than two columns e.g. with town in addition and so on.

I hope you now get the point I am hinting on.