Skip to content

Instantly share code, notes, and snippets.

@mAu888

mAu888/gist:1778670

Created February 9, 2012 09:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mAu888/1778670 to your computer and use it in GitHub Desktop.
Save mAu888/1778670 to your computer and use it in GitHub Desktop.
Download ZIP
Swap two sort fields in one update clause
Raw
gistfile1.sql
UPDATE
`table` a, `table` b
SET
a.`sort` = b.`sort`,
b.`sort` = a.`sort`
WHERE
a.`id` = 1 AND b.`id` = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment