KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My query select * from product where productId in(25,36,40,1,50); Result shows as follows `productId ProductName Qty Price` ------------------------------------- `1 | namesome | 5 | 25.00` `25 | namesome | 5 | 35.00` `36 | namesome | 5 | 35.00` `40 | namesome | 5 | 35.00` `50 | namesome | 5 | 35.00` I did not use any order by clause, But its automatically applied order by productId , I need result with out any sort, as follows `productId ProductName Qty Price` ------------------------------------- `25 | namesome | 5 | 25.00` `36 | namesome | 5 | 35.00` `40 | namesome | 5 | 35.00` `1 | namesome | 5 | 35.00` `50 | namesome | 5 | 35.00` How can I achieve this? Database Engine: MyIsam, Collation: utf8_general_ci, PrimaryKey on productId
Tags (comma-separated)
Save Edits
Cancel