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