For example:
select GROUP_CONCAT(seatnum)
from busses
where bus_id=19229;
This is resulting as 7,1,2,3,1,7,4
. I have to get only 7,1,2,3,4
, i.e unique values in mysql query. Distinct
will not solve my problem here.
So pls let me know is their any other ideas in this? Thanks.