Change Values In One Field

[The Equivocate]

I have my vbgames table, and I want to be able to change the 'arcadepass_jackpot' on all of my 300+ games all at once, instead of going into each one and editing them one by one. Is there an SQL query that I can run that will alter all 'arcadepass_jackpot' fields from 500 to 250 (or any other number)?

[Davey]

[sql]UPDATE vb3_arcadepass_jackpot
SET fieldname='250'
WHERE fieldname='500'[/sql]
Change vb3_arcadepass_jackpot to the correct 'arcadepass_jackpot' table.
Change fieldname to the name of the field where the values are kept.

edit.- you know how to run that query right? in vB acp or in phpMyAdmin..

[The Equivocate]

Yep, this is what I did and it worked fine

[sql]UPDATE vbgames
SET arcadepass_jackpot='250'
WHERE arcadepass_jackpot='500'[/sql]

[Davey]

OK I almost had it.