a function which returns a string representation of the concatenated, non-NULL values of a group
please I want to use group_concat in a query using eloquent and not raw queries. here is the code …
laravel eloquent group-concatQuestion revised Really wanted a group_concat of sums... Table: shops +---------+--------+--------+ | shop_id | name | state | +---------+--------+…
mysql sum group-concatI 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-concatI have a large table with data that is not unique but needs to be. This table is a result …
mysql group-by group-concatIn 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-concatFirst, here is the query: SELECT GROUP_CONCAT(title) title, GROUP_CONCAT(description) description, skill_id, count(*) FROM jobs j …
mysql sql group-concatI 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-concatI'm probably having a no-brain moment. I want to return a series of numbers using GROUP_CONCAT from two fields …
mysql concat group-concatI have a MySQL table with requests +--------+-------------+-----+ | req_id | req_name | ... | +--------+-------------+-----+ | 1 | testrequest | ... | +--------+-------------+…
mysql group-by group-concatI 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