Updaing within a range

Databases
1

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%’

2

Did you try?

3

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