Различия
Показаны различия между двумя версиями страницы.
| Предыдущая версия справа и слева Предыдущая версия | |||
| sql:order_fields_by_id [2016/08/11 12:19] – mirocow | sql:order_fields_by_id [2016/08/11 12:19] (текущий) – mirocow | ||
|---|---|---|---|
| Строка 9: | Строка 9: | ||
| WHERE id IN (2, 10, 3, 88, 23) | WHERE id IN (2, 10, 3, 88, 23) | ||
| ORDER BY FIELD (id, 2, 10, 3, 88, 23) | ORDER BY FIELD (id, 2, 10, 3, 88, 23) | ||
| - | </sxh> | + | </code> |
| Или | Или | ||
| <code sql> | <code sql> | ||
| ORDER BY FIND_IN_SET(id, | ORDER BY FIND_IN_SET(id, | ||
| - | </sxh> | + | </code> |
| Или | Или | ||
| <code sql> | <code sql> | ||
| ORDER BY id = 2 DESC, id = 10 DESC, id = 3 DESC, id = 88 DESC, id = 23 DESC | ORDER BY id = 2 DESC, id = 10 DESC, id = 3 DESC, id = 88 DESC, id = 23 DESC | ||
| - | </sxh> | + | </code> |