mysql - Select * from table where id = ? and order by priority -


i have database fields:

  • id (int)
  • name (text)
  • priority (int)

i want show values database id = (e.g) 13 , sort them priority. e.g: field id 13 , priority 1 first other field priority 2.

how can it?

select id,name,priority table_name id=13 order priority asc; 

Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -