ORDER BY 2 things?

[erme]

How can I write something like this?

 

SELECT * FROM TableName ORDER BY RAND($rand) AND FieldName1 DESC

 

 

[trq]

SELECT * FROM TableName ORDER BY RAND($rand) FieldName1 DESC

[erme]

Doesn't seem to work

[erme]

Need the comma

 

SELECT * FROM TableName ORDER BY RAND($rand), FieldName1 DESC

[jay7981]

SELECT * FROM table ORDER BY field ASC/DESC, field ASC/DESC, field ASC/DESC.......