MySQL sub query
- by Juddling
UPDATE members SET money=money+100 WHERE username IN (SELECT username FROM forum);
Lets say I wanted to give each of my members 100 money for each post in my forum. This query works but if one member has posted more than once, they only get 100. Could someone correct this query please?