I need the correct syntax for below:
UPDATE user
"Add y to membergroupids"
WHERE NOT FIND_IN_SET(X, membergroupids)
AND posts < 40
AND posts > 15
This is what the query does:
For users not member of x (usergroup id=x) and with postcount between 14 and 40.': Make those users a member of y (usergroup id=y).
Thanks
UPDATE user
"Add y to membergroupids"
WHERE NOT FIND_IN_SET(X, membergroupids)
AND posts < 40
AND posts > 15
This is what the query does:
For users not member of x (usergroup id=x) and with postcount between 14 and 40.': Make those users a member of y (usergroup id=y).
Thanks
Comment