How to select values consisting of numerals only?

Question

I have a column like this:

I want to get the values that contain numerals only (decimal digits from 0 to 9). For the example above, I want only these records to be printed:

547856232
856987452

How can I do that?

I removed the tags for sql-server and mysql as you stated previously that you are using Postgres. Please only add tags for the DBMS you are actually using — a_horse_with_no_name, Jan 30, 2020 at 11:57
i have 50 lakhs records... i have to get a count of ones that are only numeric and avoid alphanumerics — Arshiya Mukherjee, Jan 30, 2020 at 12:01
Numeric == only digits? no minus, decimal point, leading/trailing spaces, etc.? — Akina, Jan 30, 2020 at 12:27

a_horse_with_no_name · Accepted Answer · 2020-01-30 12:02:57Z

1

You can use a regular expression for that:

select *
from the_table
where the_column ~ '^[0-9]+$';

answered Jan 30, 2020 at 12:02

77.2k14 gold badges154 silver badges192 bronze badges

Add a comment |

1 Answer 1