Well, if you truly will never have any more records, then what the heck. Use the answer in my post #14. You obviously have an unusual situation, what with having a fixed number of records.

I fully admit my advice in the prior posts was generic in nature. For the more common problem of databases that inevitably grow in time.

And note that FLOOR(id/1000) will always get you back the original table number (1 through 20), so that's always available to your code, as well.

If you didn't know, the % operator is the MODULO operator: It gives you the remainder you get when you divide the left side value by the right side value. MySQL also has a MOD() function. So you can use either id % 1000 or MOD( id, 1000 ), whichever you feel more comfortable with.