Hi
I’m usinng GROUP_CONCAT to concatinate query results,
eg : SELECT CAST(GROUP_CONCAT(`timestamp` SEPARATOR "','")AS BINARY) as `timestamp`
and it results
2010-03-05 04:38:01[B]','[/B]2010-03-05 04:38:05[B]','[/B]2009-12-24 04:15:49
i like to run above query like this
Select * from demo where demo IN(SELECT CAST(GROUP_CONCAT(`timestamp` SEPARATOR "','"))
if you see the results single quotes is missing from first and last position.
so how can we concatinate single quotes at both ends
Thanks in advance