First, add an order by clause at the end:
ORDER BY category_id
If category_id is a string, then you must treat it like an integer. There are a few ways to do this. I usually add a zero. You can also cast it.
ORDER BY category_id + 0
First, add an order by clause at the end:
ORDER BY category_id
If category_id is a string, then you must treat it like an integer. There are a few ways to do this. I usually add a zero. You can also cast it.
ORDER BY category_id + 0