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

Reply via email to