Can this be done

[tobeyt23]

I have a table:

 

id

submission_id

field_id

data

1

1

1

First Name

2

1

2

Last Name

 

Can I do one select statment and get all the field_ids combined into one column and the same for the data column?

 

 

 

 

[rhodesa]

if i understand what you are asking...no

[fenway]

Not sure what you're asking... but probably yes under certain circumstances.  Please provide desired sample output.

[aschk]

Yes but you need to decide how you're grouping those rows.

 

i.e.

SELECT GROUP_CONCAT(field_id SEPARATOR ',') 
       ,GROUP_CONCAT(data SEPARATOR ',') 
FROM <table name here>
GROUP submission_id