mysql query order by multiple items

is is possible to order by multiple rows?

I want my users to be sorted by last_activity, but at the same time, i want the users with pictures to appear before the ones without

Something like this:

SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY last_activity, pic_set DESC;

Answers


SELECT some_cols
FROM prefix_users
WHERE (some conditions)
ORDER BY pic_set DESC, last_activity;

Sort by picture and then by activity:

SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY pic_set, last_activity DESC;

SELECT id, user_id, video_name
FROM sa_created_videos
ORDER BY LENGTH(id) ASC, LENGTH(user_id) DESC

Need Your Help

IoC Factory: Pros and contras for Interface versus Delegates

c# .net design-patterns dependency-injection ioc-container

Any place where you need a run-time value to construct a particular dependency, Abstract Factory is the solution.

How to download previous version of tensorflow?

tensorflow

For some reason, I want to use some previous version of tensorflow('tensorflow-**-.whl', not source code on github) and where can I download the previous version and how can I know the correspondin...