WHERE id IN doesn't work in UPDATE
Posted
by Donator
on Stack Overflow
See other posts from Stack Overflow
or by Donator
Published on 2010-05-01T16:51:06Z
Indexed on
2010/05/01
16:57 UTC
Read the original article
Hit count: 222
UPDATE static
SET money = money + '100'
WHERE member_id IN (SELECT member_id FROM race WHERE race_id = '$race_id')"
I want to retrieve member_ids and give for all of them +100 money. What's wrong?
© Stack Overflow or respective owner