VD
Hi! Can I ask you a question about MySQL?
yes, you can
createdon. So far, it's easy. But. For the 3 first rows, I want to display 3 specifics id in a specific order. How can I do that?Size: a a a
2020 December 08
KZ
Thanks 😊 So, I want to display 6 results order by
E
Thanks 😊 So, I want to display 6 results order by
createdon. So far, it's easy. But. For the 3 first rows, I want to display 3 specifics id in a specific order. How can I do that?KZ
Am I clear?
KZ
In a first place I added
ORDER BY field(id,21,11) AND createdon DESC but it didn't work (basically it starts by 11, then 21) and if I replace createdon by menuindex id = 21 isn't displayed, that's why I think it's not a good method.МН
In a first place I added
ORDER BY field(id,21,11) AND createdon DESC but it didn't work (basically it starts by 11, then 21) and if I replace createdon by menuindex id = 21 isn't displayed, that's why I think it's not a good method.hi, you should use FIND_IN_SET
KZ
FIND_IN_SET('21,11', id) doesn't workKZ
No result
KZ
Plus, FIND_IN_SET have the exactly the result that if I use WHERE id = 21
KZ
I want to display id = 21, then 11, then the others results until I have 6 results
МН
ORDER BY FIND_IN_SET( id, '11,21' ) DESC , createdon DESC
U
А чем выводится там?
это в админке выводится у ресурса
KZ
ORDER BY FIND_IN_SET( id, '11,21' ) DESC , createdon DESC
It seems to work, except for the order. I wrote
(id, '21,11') and it display 11 then 21.KZ
And if I write
FIND_IN_SET( id, '21,11' ) ASC = 21 is the last result and 11 isn't displayedKZ
DK
@Neoziox order by case when id =21 then 0 when id=11 then 1 else 2 end id and created_on desc try this
DK
not sure about correct syntax
KZ
DM
order by field(id, 21,11), createdon desc - don't use "and " between two sorting fields, only comma