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. Part1
SELECT * FROM articles WHERE MOD(article_id, 2) = 0;
Part2
SELECT * FROM articles WHERE MOD(article_id, 2) = 1;