I have a table of products that are associated to a retailer_id in a MySQL database and I would like to do a search on that table by a keyword on the title field but I would like to return the items in a sequential pattern using the retailer_id.

Pulling my hair out with this one but basically what I want to do is the following:-

I want to search for red dress which will show all results but then I want to sequentially order by retailer_id so the final output would be:-

Thanks in advance for any help

CodePudding user response：

Using row_number you can rank each retailer_Id and order like so:

select retailer_id 
from (
    select *, Row_Number() over(partition by retailer_id order by retailer_id) rnk
    from t
)t
order by rnk, retailer_id;