need help with a Query

[Auron]

hi, basically lm doing some work on a friends forum which has a solid member base however l converted to vb and certian settings have changed, however l worked out that by running the right query l could update all members options at once (was easy when l noticed the options table within users number change) however because my member base arent so internet inclined, personally l dont see why the guy baught a licence if he doesnt know how to use it

however the query l ran was:

UPDATE `user` SET options='1175';

(l think the option code was 1175 anyways hehe not looking at the code right now)

basically the sql code l want help with is basically to also update the editor members use to the enhanced wysywig(sp?) along with all the other options set as well as l noticed even when l change the option on the test account l had the number in the options coloumb didnt change unless l edited an option before that section in "Edit Options".



would be very greatful if someone knew the right query to run or tell me what l could be missing

TIA

Auron