Hello,
the mysql-documentation says, that CONCAT or CONCAT_WS is not a function to
use with GROUP BY, but I tried this in version 3.22 and it worked. Why
doesn't it work with the latest version?
Example:
SELECT * FROM bids;
+----+-----------+---------+
| id | comment | project |
+----+-----------+---------+
| 1 | hello | 3 |
| 2 | world | 3 |
+----+-----------+---------+
SELECT CONCAT_WS(' ', comment) FROM bids GROUP BY project;
+-------------------------+
| concat_ws(' ', comment) |
+-------------------------+
| hello world |
+-------------------------+
Greetings,
Thomas
---------------------------------------------------------------------
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
