How to upgrade the user account

[mmarif4u]

Hi every body..
I have this query:


update `o_subscription` set cdlevel=02 WHERE icactive = 'X' and dtexpire >= '2006-01-01' and cdlevel= 01



i want to upgrade the user whose account is expired in 2006-01-01
and dtexpire >= '2006-01-01'

Will this query work..
i also want that upgrade the user level to coming level
example is level 2 to level 3.
i use this query with date ..
>= what will this operators do.

Thanks in advance

[guelphdad]

that will update all accounts with a dtexpire value of 2006-01-01 and later, that is probably not what you want. It would update an account with a dtexpire from today and one from next year as well.

The >= sign is greater than or equal to.

[mmarif4u]

Thanks for Help.