[RESOLVED] Extract Specific Format

[maskme]

Dear All

I wish to extract mobile nos from my database, but only those mobile nos where the specific format is met for e.g.

97150???????

where 97150 is the default country + code
where ??????? is any 7 numeric no.

Could any1 guide me on this, please.
Awaiting for your help
Thanks

[bradgrafelman]

That would depend on how your table is set up... do you just have a field of phone numbers that are all run together like that? If so...

SELECT `number` FROM `myTable` WHERE `number`LIKE '97150_______'

[maskme]

dear bradgrafelman

thanks for the help, but how many under_scores i would need to put to get 7 __________ ???

let me know

[bradgrafelman]

Well, one _ matches one character in a LIKE statement, so if you're expecting 7 numbers after 97150, you would use 7 underscores.

Alternatively, you could do some regular expression matching:

SELECT `number` FROM `myTable` WHERE `number` REGEXP '^97150[0-9]{7}$'

[Houdini]

You could try

$number ="971503380550";
if (preg_match("/97150\d{7}/",$number)){
  echo "$number is a valid number!";//valid match
}
else{
  echo "$number is not valid!";//not a good number
}

[bradgrafelman]

Well that would tell if you the number matches... but he's trying to pull these numbers from a database first.

[maskme]

dear bradgrafelman & Houdini

thank you both for your generous help

regards