Zester

I wonder how many of you know SQL.

$sql="
UPDATE records set appear_order='3' WHERE id='19' ;
UPDATE records set appear_order='5' WHERE id='16' ;
UPDATE records set appear_order='4' WHERE id='17' ;
UPDATE records set appear_order='6' WHERE id='20' ;
UPDATE records set appear_order='2' WHERE id='18' ;
";

is there a better shorter way to do this query? can all these updated even be done at once?

__________________
* Mainstream ? $65 per sale
* new male contraception