Llamaman
05-22-2005, 09:40 AM
I'm not an expert with MySQL queries so if anyone could tell me if this is possible then I would be greatful.
I would like to create a query that subtracts 150 from a MySQL table field's data.
For example, I have a field in the VBulletin members table named "points". I would like to subtracting 150 "points" from each user. Is there a query that I can run to reduce every user's points by 150?
Thanks.
I would like to create a query that subtracts 150 from a MySQL table field's data.
For example, I have a field in the VBulletin members table named "points". I would like to subtracting 150 "points" from each user. Is there a query that I can run to reduce every user's points by 150?
Thanks.