krishnakhanna — 2010-02-10T06:31:37-05:00 — #1
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 — 2010-02-10T06:33:36-05:00 — #2
Did you try?
krishnakhanna — 2010-02-10T08:00:12-05:00 — #3
After executing Update temp4acajoom SET confirmed = '1' where user_id between '1%' and '20%'
I get the desired response so solved!!!!