Friends, good afternoon.
Can you please tell me the way to solve the following situation (Laravel):
There is a table rows:
id name
And there is a table rows_user_sort:
user_id sort
this string lies a json object c row.id and sort - order number for sorting:
[{"id": 244, "sort": 0}, {"id": 4, "sort": 1}, {"id": 20, "sort": 2}, {"id": 21, "sort": 3}, {"id": 22, "sort": 4}, {"id": 15, "sort": 5}, {"id": 24, "sort": 6}]
How to sort rows by a similar json object?
Thanks in advance.