Splitting of articles by article ids
Jump to navigation
Jump to search
Case1: Articles Numbered IDs
If the article number is a digit, split the article into two parts based on a remainder of 0 or 1, resulting in two nearly equal halves.
(1) Part1
SELECT * FROM articles WHERE MOD(article_id, 2) = 0;
(2) Part2
SELECT * FROM articles WHERE MOD(article_id, 2) = 1;