# Optimize Select mysq - trouble

**URL:** <https://forum.kirupa.com/t/optimize-select-mysq-trouble/327139>\
**Category:** programming\
**Created:** [February 8, 2012, 2:52pm UTC](https://forum.kirupa.com/t/optimize-select-mysq-trouble/327139 "2012-02-08T14:52:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jerome\_chevreau](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jerome\_chevreau](https://forum.kirupa.com/u/jerome_chevreau)\
**Post date:** [February 8, 2012, 2:52pm UTC](https://forum.kirupa.com/t/optimize-select-mysq-trouble/327139/1 "2012-02-08T14:52:27Z")

</div>

Hi there,  
I have a table which contains two or more row per item.  
So per item i will have 3 data for example(as column key will have price, description,extra info). the reason i did it like that is that later on i can come and customize an item and add an extra details or two ie. name, type etc…

Is there a way to group all of them under one data when using the SELECT?

The only i can do this is to use subqueries SELECT within a case statement, but would it not be slow when there will be thousands and thousands of rows?

Please if anybody can help me, it will be great.

Thanks a lot,

regards

jerome