Updaing within a range

[krishnakhanna]

Hi all,
Basically I need to update the db having a range as below, will this query work or is there any other way?

Update number SET SID = 'LYK' where Number between '32223%' and '33444%'

[guido2004]

will this query work?

Did you try?

[krishnakhanna]

After executing Update temp4acajoom SET confirmed = '1' where user_id between '1%' and '20%'
I get the desired response so solved!!!!