mysql - Create different result set using one result set -

by using mysql, got result like

    count   date        content     19      2015-01-02  test1     6       2015-01-02  test2     3       2015-01-03  test3     12      2015-01-04  test4     48      2015-01-04  test5     10      2015-01-05  test6 

i want divide result in different result set using date value. want result set like,

    count   date        content     19      2015-01-02  test1     6       2015-01-02  test2      count   date        content     3       2015-01-03  test3     12      2015-01-03  test4      count   date        content     48      2015-01-04  test5     10      2015-01-04  test6 

is possible create different result set using 1 result set.

to use resultset in query condition set of queries need cursor.

please check out basics of cursor usage here , in docs

delimiter $$  create procedure group_results_by_date  begin   declare v_finished integer default 0;  declare cdate date default "2015-01-01";   -- declare cursor getting list of dates  declare date_cursor cursor      select distinct (date) yourtable;   -- declare not found handler  declare continue handler          not found set v_finished = 1;   open date_cursor;   get_content: loop   fetch date_cursor cdate;   if v_finished = 1   leave get_content;  end if;   -- select query different dates  select count, date, content yourtable date = cdate;   end loop get_content;   close date_cursor;  end$$  delimiter ; 

you can call procedure by

call group_results_by_date();