SELECT id,name,phone_number FROM contacts WHERE (LENGTH(phone_number) = 10 OR phone_number LIKE '___-___-____') AND phone_number NOT LIKE '0%' AND REPLACE(phone_number,'-','') REGEXP '^[0-9]+$' ORDER BY id
SELECT id,name,phone_number FROM contacts WHERE (LENGTH(phone_number) = 10 OR phone_number LIKE '___-___-____') AND phone_number NOT LIKE '0%' AND REPLACE(phone_number,'-','') REGEXP '^[0-9]+$' ORDER BY id