Custom Sort order PHP + MySQL

Question

I have these 2 columns in the table and my PHP code on my site is connected to it.

username | primary_group

I currently have it being sorted by username but how would I make it sort by primary_group with the groups in a certain order without making a sort column in the group name table and link the tables?

Currently, I have:

SELECT username, primary_group FROM table_name ORDER BY username.

Tim Biegeleisen · Accepted Answer · 2017-09-29 02:20:00Z

1

You could use MySQL's ORDER BY FIELD capability to specify a certain custom order to use when sorting on primary_group:

SELECT
    username, primary_group
FROM
    table_name
ORDER BY
    FIELD(primary_group, 'group1', 'group2', 'group3', ...)

answered Sep 29, 2017 at 2:20

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Custom Sort order PHP + MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related