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

query problem with GROUP BY and ORDER BY

Hi all, I have a table including two colums: names and apartment numbers: apt #| name -- 1 | Smith Joe 1 | Smith Anne 2 | Doe Richard 3 | Svensen Mike 3 | Brant Liza I need to get a list in alphabetical order, but with people in the same apt keept together: Brant,

Extracting fields from a table

I want to select all entries in my table that in a column with given dates findes all dates inbetween $from_date - $to_date. (These are vars that the user supplies from the HTML-page). I don't know how to set up the SELECT query. I tried the following way but it didn't work: SELECT * FROM