select query - order by help

I need to sort a select query.

Table is as follows:


license |
free |
commercial |
free |
gpl |
free |
gpl |
commercial |

I need this to order by all rows with free in the license column first and then gpl and then commercial.

How can i do select statement and use order by license and the entry to sort it like this:

free
free
free
gpl
gpl
commercial
commercial

SELECT * FROM ------- order by license and input";
$result = @mysql_query($sql,$connection) or die(mysql_error());

Without doing a subselect, I'm not sure you can do it this way. Best as I know, you can only sort by the default order, ascending, or descending.

can i do multiple subselects to select the different entries in order to show them properly

You could do a statement that selects only free and gpl, sorted ascending, then union on the commercial?

i tried this but it doesnt work. Can you give me an example?

SELECT * FROM ------ WHERE license = '(SELECT * FROM ------ WHERE license='Commercial')'";

SELECT * FROM table WHERE license IN ('free', 'gpl') ORDER BY license UNION SELECT * FROM table WHERE license = 'commercial'

Thanks for the example but i get this error: Incorrect usage of UNION and ORDER BY

I fixed, the select statements need to be wrapped with ()

Hm... strange, I've done it without parenthesis, but hey, if it works, great!