moving entries in mysql?

Hello everyone!

Is there any way to move an entry in a database.

for example if it looks like this:

item_no | size
111 | XS
211 | XL
322 | S

Is there anywat to get 322 to be the first entry?

Best regards

Ordering is only applicable to result sets, not tables. Specify an order by clause in your select statement.

select * from products 
order by case when item_no = 322 then 0 else 1 end

Concepts such as first or last does not have any meaning in a relational database.

ah I see...thanks for the help!