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 with 1 query. As an example, lets take a random product and look at the parimetric data for it. SELECT es.ProdID, ev.Text FROM especee as es INNER JOIN evocee as ev ON (es.BodyID=ev.ID) WHERE es.ProdID = 45607; +--------+---------------------------------------------------+ | ProdID | Text | +--------+---------------------------------------------------+ | 45607 | Limited warranty - 1 year | | 45607 | 1 year warranty | .... | 45607 | External | | 45607 | POTS filter | +--------+---------------------------------------------------+ I want to concat all the values of "Text" into 1 row in another table. I have this so far: UPDATE X_Search.text_search as ts INNER JOIN especee as es ON (ts.product_uid = es.ProdID) INNER JOIN evocee as ev ON (es.BodyID=ev.ID) SET ts.txt = CONCAT(ts.txt, ev.Text) WHERE ts.product_uid = 45607; but all that gets appended is the 1st row, ie "Limited warranty - 1 year" Is what I'm trying to to possible, and if it is, am I going down the right road? -- -S -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
