Using Mysql WHERE IN clause
+--------------+---------------------------+-----------------------+
| id_condicion | descripcion_condicion | parent_condition_id |
+--------------+---------------------------+-----------------------+
| 12 | SALIDA SABADO | 0 |
| 120 | 7 NOCHES DE MARTES A MARTE| 36,98,15 |
| 121 | 7 NOCHES DE MIERCOLES A MI| 36,99,106 |
| 122 | 7 NOCHES DE JUEVES A JUEVE| 36,89,107 |
| 123 | 7 NOCHES DE VIERNES A VIER| 36,100,108 |
| 142 | 14 NOCHES EXCEPTO ENTRADA | 29,104,112 |
| 143 | 14 NOCHES EXCEPTO ENTRADA/| 29,105,113 |
| 144 | 14 NOCHES EXCEPTO ENTRADA/| 29,57,58 |
| 145 | 7 NOCHES EXCEPTO ENTRADA/S| 36,31,101,38,109 |
| 15 | SALIDA MARTES | 0 |
| 16 | SEMANA NATURAL | 0 |
| 17 | 3 NOCHES ESTANCIA MINIMA | 0 |
| 20 | 7 NOCHES EXCEPTO ENTRADA/S| 36,31,38 |
| 25 | 4 NOCHES ESTANCIA MINIMA | 0 |
| 27 | 5 NOCHES ESTANCIA MINIMA | 0 |
| 28 | 7 NOCHES DE SABADO A SABAD| 36,10,12 |
| 29 | 14 NOCHES ESTANCIA MINIMA | 0 |
| 30 | 14 NOCHES DE SABADO A SABA| 29,10,12 |
| 31 | ENTRADA EXCEPTO DOMINGO | 0 |
| 32 | 4 NOCHES EXCEPTO ENTRADA/S| 25,31,38 |
| 35 | SABADO/MARTES SALIDA | 0 |
| 36 | 7 NOCHES ESTANCIA MINIMA | 0 |
| 37 | 7 NOCHES ENTRADA/SALIDA SA| 36,92,35 |
| 38 | SALIDA EXCEPTO DOMINGO | 0 |
| 39 | 5 NOCHES EXCEPTO ENTRADA/S| 27,31,38 |
| 41 | SALIDA DOMINGO | 0 |
+--------------+---------------------------+-----------------------+
i have a table as described above, now if parent_condition_id is not equal to zero then select id_condicion which all are there in parent_condition_id. please help me to execute this query using mysql.
the column parent_condition_id contains the id_condicion id's .
thanks in advance