<p>I am trying to use concat_ws inside a group_concat command. With a query, which simplified looks like: </p>

<pre><code>SELECT item.title, GROUP_CONCAT( CONCAT_WS(  ',', attachments.id, attachments.type,     attachments.name ) )  as attachments
FROM story AS item
LEFT OUTER JOIN story_attachment AS attachments ON item.id = attachments.item_id
GROUP BY item.id
</code></pre>

<p>I get the attachments column as a Blob type. is it it possible to get it as a string instead of Blob?</p>

You need to cast as a char..
```
```
SELECT item.title, GROUP_CONCAT( CAST(CONCAT_WS(',', attachments.id, 
attachments.type, attachments.name ) as CHAR ) ) as attachments 
FROM story AS item 
LEFT OUTER JOIN story_attachment AS attachments 
ON item.id = attachments.item_id GROUP BY item.id
```
```