using group_concat in PHPMYADMIN will show the result as [BLOB - 3B]

user_67153 0
Viewed 36802

I have a query which uses the GROUP_CONCAT of mysql on an integer field.
I am using PHPMYADMIN to develop this query. My problem that instead of showing 1,2 which is the result of the concatenated field, I get [BLOB - 3B].

Query is

SELECT rec_id,GROUP_CONCAT(user_id)
FROM t1
GROUP BY rec_id

(both fields are unsigned int, both are not unique)

What should I add to see the actual results?

phpmyadmin group-concat group-by casting mysql
7 Answers

In the latest Phpmyadmin

After running query, you will see some results and then dot ..

so just click on options (which is on top of the query result)

Then Just select

Full texts

radio button, default is Partial texts

Then press Go button and you will see full result

user_63094570
Related