Splitting of articles by article ids: Difference between revisions
Jump to navigation
Jump to search
(Created page with " == 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. P...") |
(No difference)
|
Revision as of 10:04, 13 December 2023
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;