Hi All,

If i give values in inclause directly results are coming fine(2 rows) as like below, but if i use concat instead of values, its returning only one row and that is not the expected output, please help me in this regard.

mysql> select c_id,c_name from category where c_id in (870,854);
+------+---------------+
| c_id | c_name |
+------+---------------+
| 854 | Telugu |
| 870 | Telugu Events |
+------+---------------+
2 row in set (0.04 sec)

mysql> select c_id,c_name from category where c_id in (select concat(870,',',854) as c_id);

+------+---------------+
| c_id | c_name |
+------+---------------+
| 870 | Telugu Events |
+------+---------------+
1 row in set (0.04 sec)



Thanks.