So, I have a large set of numbers, basically 1001 .. 150000 for a database using MySQL

There are a ton of gaps in the IDs on the database, so not all IDs exist. It can go from 100000 – 10500, then the next number will be 10675, and so fourth.

I want to make the IDs shortened, such as 1001..3000, x, x, x, 55000..101000 etc

I’m sure it’s simple. Thanks in advanced!!

SELECT id FROM table_name WHERE data = x 

give me above info.

I used

select group_concat(id) from items where id>1000

to get all ids in a comma separated list. How do I shrink this to be more clean? Basically to add “..” to a series of sequential numbers

I am using perl – just not sure of the syntax to make it work