From String to Blob


From String to Blob



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

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 

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




mysql import csv problem

1:



Setting up a Python web development environment on OS X
You need to cast as a char...
Empty string in not-null column in MySQL?
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 


Possible Causes for a Large Number of Sleeping Connections to a MySQL Server?


Mysql strip time component from datetime

2:



SQL (MySQL): Match first letter of any word in a string?
Although I suspect CAST is the appropriate answer, it's worth mentioning that I ran into a similar thing in the past which turned out to be down to a strange/conflicting collation type and character set..
MySQL Cross-Table Count(*) Query Help


How can I Cause a Deadlock in MySQL for Testing Purposes


76 out of 100 based on 56 user ratings 1006 reviews