Is This Possible?

[*Alexz*]

yep one sec i think i can
let me think lol xD

[King Shaun]

Yes it would be something like this:

MODIFY WHERE 'accounts' ('flags' = '8' to '0')

That is a pure guess but I am sure it is something like this.

[*Alexz*]

Yes it would be something like this:

MODIFY WHERE 'accounts' ('flags' = '8' to '0')

That is a pure guess but I am sure it is something like this.

you where close =P

update `accounts` set flags= '8 ' where flags=0

try that

[King Shaun]

No Alexz, you are wrong..

update 'accounts' set 'flags' = '0' where 'flags' = '8'

That should work if I am correct.

[*Alexz*]

i almost got it =P

[King Shaun]

Haha, 2d is viewing this thread, he will probaly correct me too!

[*Alexz*]

yep thats 2d for ya xD

[farrer686]

None of them worked? Anyone else ??

[2dgreengiant]

Haha, 2d is viewing this thread, he will probaly correct me too!

well

update accounts
set flags = 0
where flags = '8'

works for me in sqlyog

[King Shaun]

I think that should work what 2d said if it does not try this:

update 'accounts'
set 'flags' = '0'
where 'flags' = '8'

But I am sure that what 2d said should work..

[2dgreengiant]

i know mine works as i tested it be4 hand :P