Question

Sort by order of values in a MySQL select statement IN clause?

Answer 1

Answer:

Explanation:

ORDER BY has two values:

1) ASC means Ascending Order.

2) DESC means Descending Order.

The query goes as under:

Suppose we have table 'student' with fields id,name,marks

$query = "SELECT * FROM student ORDER BY marks ASC" ;

Syntex:

$query = "SELECT * FROM table_name ORDER BY field_name ASC/DESC"