Q:

query on sql MySQL 5.1 - find phone numbers with specific area code

In a sql based query, I need to check that the persons I select from data should have a cell phone with area code 256. How do we check this? I have cell phone numbers as BIGINT.

A:

have you tried simple soln like
mysql:
select * from table where cellno like '256%'

