Hi

I have read quite a few selcet+update questions in here but cannot understand how to do it. So will have to ask from the beginning.

I would like to update a table based on data in another table. Setup is like this:

- TABLE a ( int ; string )
ID     WORD
1      banana
2      orange
3      apple

- TABLE b ( "comma separated" string ; string )
WORDS  TEXTAREA
0      banana                  -> 0,1
0      orange apple apple      -> BEST:0,2,3 ELSE 0,2,3,3
0      banana orange apple     -> 0,1,2,3

Now I would like to for each word in TABLE a append ",a.ID" to b.WORDS like:

SELECT id, word FROM a
(for each) -> UPDATE b SET words = CONCAT(words, ',', a.id) WHERE b.textarea like %a.word%

Or even better: replace the word found in b.textarea with ",a.id" so it is the b.textarea that ends up beeing a comma separeted string of id's... But I do not know if that is possible.