Skip to content

Instantly share code, notes, and snippets.

@jgdoncel

jgdoncel/order.sql

Created October 2, 2013 13:50
Show Gist options
  • Save jgdoncel/6794116 to your computer and use it in GitHub Desktop.
Save jgdoncel/6794116 to your computer and use it in GitHub Desktop.
Download ZIP
Ordenar en base a un campo En el ejemplo se ordenan las líneas de pedido en su orden natural pero manteniendo unidas las que son del mismo color.
Raw
order.sql
Select * FROM pedidos_lineas
where id_pedido=33
order by find_in_set(color, (SELECT GROUP_CONCAT(DISTINCT(color)) FROM pedidos_lineas WHERE id_pedido=33));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment