Have you looked at the GROUP_CONCAT() function?
(http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html)
It would make your update look like:
CREATE TABLE tmpList
SELECT ts.product_uid as UID, Group_Concat(ev.Text) as newtext
FROM X_Search.text_search as ts
INNER JOIN especee as es
ON
Further to my Full Text question the other day, I'm trying to add the
parimetric data to the field that gets searched.
We have a script that runs periodically to update this table. I can do
what I want in that script no problem, but it would be more elegent if
I could acheive the same results wit
