Skip to content

Instantly share code, notes, and snippets.

@mdurys
Created December 4, 2014 11:24
Show Gist options
  • Select an option

  • Save mdurys/994fd6744f5969e08209 to your computer and use it in GitHub Desktop.

Select an option

Save mdurys/994fd6744f5969e08209 to your computer and use it in GitHub Desktop.
Identify Polish mobile phone numbers
SELECT COUNT(*)
FROM customer
WHERE is_active = 1
AND (
register_phone LIKE '50%'
OR register_phone LIKE '51%'
OR register_phone LIKE '53%'
OR register_phone LIKE '57%'
OR register_phone LIKE '60%'
OR register_phone LIKE '66%'
OR register_phone LIKE '69%'
OR register_phone LIKE '72%'
OR register_phone LIKE '73%'
OR register_phone LIKE '78%'
OR register_phone LIKE '79%'
OR register_phone LIKE '88%'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment