Help with creating a short SQL Quiery Please

[paintballer.ie]

Hey lads, I have the community news letter by Provb but I can not get proper support from them

The installation creates a profile option to subscribe to the community news letter. However this option yes or no are blank by default. I need to run an sql query to set all members to 'yes'.

What I got so far was:

PHP Code:
UPDATE userfield set fieldX = 'yes'

If you have a table prefix, include it. Replace X with the profile field ID Make sure you've double checked what you replaced, otherwise you may change the wrong one

Here is where I am stuck and have not got help. I use the prefix vb_ , so where where to I put this?

Thanks in advance for pointing me in the right direction

[051119]

PHP Code:

UPDATE vb_userfield set fieldX = 'yes' 


[paintballer.ie]

Thanks