Simple SELECT/CONCAT query?

Hi, I have a question on how to make a simple search... I have two columns in a MySQLdb-table: item, price I want to list all items with their prices. However, items with the same price should be concatenated. I've looked through the manual - but can't figure out how to concat rows

R: Simple SELECT/CONCAT query?

SELECT/CONCAT query? Hi, I have a question on how to make a simple search... I have two columns in a MySQLdb-table: item, price I want to list all items with their prices. However, items with the same price should be concatenated. I've looked through the manual - but can't figure out how