i have one mysql table name called mem\_exam\_dates.

```
+---------+-------------+----------------------------------+
| rec_id  |  mem_name   |            exam_dates            |
+---------+-------------+----------------------------------+
|    1    |    Raju     | 2015-01-05,2015-05-09,2018-05-09 |
|    2    |    Rajes    | 2015-10-05,2015-12-09,2018-09-09 |
+---------+-------------+----------------------------------+

```

now i want to display the result as below.

```
+-------+---------------+
|  Raju |   Exam Dates  |
+-------+---------------+
|      2015-01-05       |
|      2015-05-09       |
|      2018-05-09       |
+-----------------------+

```

i am writing the query like

select \* from mem\_exam\_dates where rec\_id=1

from the above query i am getting total exam dates as single string.

but i want the exam dates as below.

```
+----------------+
|   2015-01-05   |
|   2015-05-09   |
|   2018-05-09   |
+----------------+

```

what is the query for that one?

if anybody knows let me know...

Thanks in advance

kalyan