Mysql group_concat problem

Question

I am just trying to find out if it is possible for a MYSQL function to GROUP_CONCAT

return this data type. Here is the script

SELECT GROUP_CONCAT(marks) AS `i need only 40 int in this column`  FROM marks

when i execute this query the result is shown as follows

enter image description here

Result required 40

+3

mysql group-concat

Query Master 04 Apr 12 at 12:21

source to share

3 answers

Pablo santa cruz · Answer 1 · 2012-04-04T12:24:55+0000

Try the following:

select group_concat(m.marks) from 
    ( select distinct marks from marks limit 40 ) m

knittl · Answer 2 · 2012-04-04T12:32:08+0000

First advice: normalize your database tables - the field should only contain one value.

Now the solution for your specific problem: MySQL has a function FIND_IN_SET

that should do what you want:

SELECT marks
FROM marks
WHERE FIND_IN_SET('40', marks)

Ankit sharma · Answer 3 · 2012-04-04T12:42:38+0000

Your syntax

SELECT GROUP_CONCAT(marks) AS `i need only 40 int in this column`  FROM marks

works correctly. You give a GROUP_CONCAT(marks)

name i need only 40 int in this column

, so it shows what you are speaking through the syntax.

"Result 40 required"

What does this mean when you are using group_concat and want to write where the labels are 40? Why not use a query like

select * from table_name where marks='40'

If group_concat is compultion then use

SELECT GROUP_CONCAT(marks) AS `i need only 40 int in this column`  FROM marks where marks='40'