Top "Group-concat" questions

a function which returns a string representation of the concatenated, non-NULL values of a group

Group_concat - laravel eloquent

please I want to use group_concat in a query using eloquent and not raw queries. here is the code …

laravel eloquent group-concat
How to use sum() within a group_concat()?

Question revised Really wanted a group_concat of sums... Table: shops +---------+--------+--------+ | shop_id | name | state | +---------+--------+…

mysql sum group-concat
Ordering in a MySQL GROUP_CONCAT with a function in it

I want to order the results in a GROUP_CONCAT function. The problem is, that the selection in the GROUP_…

sql mysql sql-order-by group-concat
MySQL get first non null value after group by

I have a large table with data that is not unique but needs to be. This table is a result …

mysql group-by group-concat
Sqlite group_concat ordering

In Sqlite I can use group_concat to do: 1...A 1...B 1...C 2...A 2...B 2...C 1...C,B,A 2...C,B,…

sqlite group-concat
is there a length limit to group_concat or another reason why it would not work on a text field

First, here is the query: SELECT GROUP_CONCAT(title) title, GROUP_CONCAT(description) description, skill_id, count(*) FROM jobs j …

mysql sql group-concat
GROUP_CONCAT in SQLite

I am having data like this 1 A 1 B 1 C 1 D 2 E 2 F 3 G 3 H 3 I 3 J 3 K by using this …

sql sqlite android-sqlite group-concat
MySQL GROUP_CONCAT multiple fields

I'm probably having a no-brain moment. I want to return a series of numbers using GROUP_CONCAT from two fields …

mysql concat group-concat
Conditions in MySQL GROUP_CONCAT

I have a MySQL table with requests +--------+-------------+-----+ | req_id | req_name | ... | +--------+-------------+-----+ | 1 | testrequest | ... | +--------+-------------+…

mysql group-by group-concat
How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?

I somehow need this feature,but MySQL doesn't support it at this moment. I'm using GROUP_CONCAT(CONCAT(...)) to generate …

mysql limit group-concat