在SELECT * FROM view_table中结果始终为
-----------------------
|| id || author ||
-----------------------
|| 1 || a ||
|| 1 || c ||
|| 1 || b ||
|| 2 || d ||
|| 3 || e ||
但是当SELECT * FROM view_table WHERE id = 1时,结果是
-----------------------
|| id || author ||
-----------------------
|| 1 || a ||
|| 1 || b ||
|| 1 || c ||
要么
-----------------------
|| id || author ||
-----------------------
|| 1 || b ||
|| 1 || c ||
|| 1 || a ||
要么
-----------------------
|| id || author ||
-----------------------
|| 1 || a ||
|| 1 || c ||
|| 1 || b ||
要么
..
我想SELECT * FROM view_table WHERE id = 1并以与SELECT * FROM view_table相同的顺序获取结果.如何解决它
谢谢.