Skip to main content

Return to Answer

improved formatting and fixed grammer
Source Link
Michael M.
Michael M.
  • 10.8k
  • 11
  • 20
  • 40

Sometimes you just need to check whether your query has the right order and the way of order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This won't run until you add the waydirection (DESCDESC or ASCASC) of the ordering to the query.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

Sometimes you just need to check whether your query has the right order and the way of order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This won't run until you add the way (DESC or ASC) of the ordering to the query.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

Sometimes you just need to check whether your query has the right order and the way of order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This won't run until you add the direction (DESC or ASC) of the ordering to the query.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

improved formatting and fixed grammer
Source Link
edit approved Sep 24, 2023 at 3:37
DevThiman
edit approved Sep 24, 2023 at 3:37
DevThiman
  • 1.1k
  • 1
  • 12
  • 26

Sometimes you just need to check ifwhether your query has the right Orderorder and the way of Orderorder.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This wontwon't run until you add the way (DESC or ASC) of the ordering to the query.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

Sometimes you just need to check if your query has the right Order and the way of Order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This wont run until you add the way (DESC or ASC) of the ordering to the query

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

Sometimes you just need to check whether your query has the right order and the way of order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This won't run until you add the way (DESC or ASC) of the ordering to the query.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.

Source Link
Gabo3D
Gabo3D
  • 51
  • 2

Sometimes you just need to check if your query has the right Order and the way of Order.

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 );

This wont run until you add the way (DESC or ASC) of the ordering to the query

GROUP BY pp.id_product
FIELD(pp.id_product, 1600, 1870, 2300 ) DESC;

This will do the trick as well without messing with the session and global settings of the server.