How to fetch single rows randomly?
Hello, I have a situation where I need to fetch recipes 1 by 1.
Correct me if I'm wrong but so far it seems that If was to fetch unique recipes like this:
10 queries would simply return results in this id sequence - 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 correct?
As you can see from the picture first 4 results are recipes with tuna, which would result in bad UX for users who want to fetch recipes 1 by 1.
How can I make it random or at least group them so that I know that the next recipe user fetches won't be from the same "group".
Ideally result sequence would looks something like this:
Tuna..., chicken..., pizza..., tuna..., chicken and so forth...
Correct me if I'm wrong but so far it seems that If was to fetch unique recipes like this:
10 queries would simply return results in this id sequence - 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 correct?
As you can see from the picture first 4 results are recipes with tuna, which would result in bad UX for users who want to fetch recipes 1 by 1.
How can I make it random or at least group them so that I know that the next recipe user fetches won't be from the same "group".
Ideally result sequence would looks something like this:
Tuna..., chicken..., pizza..., tuna..., chicken and so forth...
