- Check if the phone number doesn't contain any characters. (valid number)
- Check if the area code is 965 or null (assumption).
- Check if the phone number's length is 7 (6 for numbers that start with 8).
--------
- MOC (add 20000000): 2, 3, 41, 42, 43, 45, 46, 47, 48, 49, 500, 503, 504, 52, 53, 54, 551, 552, 553, 56, 571, 572, 573, 574, 575, 576, 577
- ZAIN (add 90000000): 40, 44, 702, 71, 72, 73, 74, 75, 76, 78, 79, 9
- WATANIYA (add 60000000): 501, 502, 505, 506, 507, 508, 509, 51, 550, 554, 555, 556, 557, 558, 559, 570, 578, 579, 58, 59, 6, 700, 701, 703, 704, 705, 706, 708, 709, 770, 771, 772, 773, 774, 775, 776, 778, 779
- MOC-Buisness (add 1000000): 8
A simple update stmt will do!
7 comments:
Yeah that helps a lot.. thanks ;*
i hate them for doing this :(
I don't get it :S
Thanks 7abebti ;*
q8honey and palomino:
u're most welcome :):):)
dandoon:
Me tooooooooooooooooo
hottie:
this is what i did at work to convert all phone numbers in the DB (~ 15,000 records) :)
thaanx this was very helpful!
ma kint a3arif il 7 oo mushtaqat'ha 7ag zain wila wa6aniya
u're most welcome :)
Post a Comment