The following SQL statement: mysql> SELECT equipment_name FROM equipment;
Returns the following resultset: +-------------------+ | equipment_name | +-------------------+ | Easel | | Paper Grocery Bag | | Paper Plates | | Colored Pencils | +-------------------+ Is it possible (in mysql) to create an SQL statement that would return this result set (a single string containing all the values of equipment_name from the table equipment, separated by spaces or commas or whatever)?: Easel Paper Grocery Bag Paper Plates Colored Pencils Thanks! Justin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php