PHP/MySQL - Sorting data starting with specific rows

Question

I have MySQL table with similar data

France  - 1
Germany - 2
Italy   - 3
France  - 5
Germany - 3
France  - 2

I want to select everything (It's easy SELECT * FROM table), but I want to sort data the way that France will be always first, so outcome should be:

France  - 1
France  - 5
France  - 2
Germany - 2
Germany - 3
Italy   - 3

Can this be done on MySQL side or I should do this inside foreach statement?

Thank you.

juergen d · Accepted Answer · 2013-10-30 07:57:46Z

3

Either

select * from your_table
order by country <> 'France',
         country

or

select * from your_table
order by case when country = 'France'
              then 1
              else 2
         end,
         country

answered Oct 30, 2013 at 7:57

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

2 Comments

Wickd Over a year ago

I just found "select * from table order by field(county, 'FRANCE'), variety" this is better or...?

juergen d Over a year ago

Whatever works for you is fine. There are acually even more possibilities to do it

Vipin · Accepted Answer · 2013-10-30 08:20:58Z

0

you can also do this by

$result=mysql_query("select * from   
   countrydata order by country ASC");
while($row=mysql_fetch_row($result)){
    $id=$row[0];
    $name=$row[1];
    echo $name."&nbsp;".$id."<br>";
}

answered Oct 30, 2013 at 8:20

Vipin

1637 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL - Sorting data starting with specific rows

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related