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%'
Did you try?
After executing Update temp4acajoom SET confirmed = '1' where user_id between '1%' and '20%'
I get the desired response so solved!!!!