Splitting of articles by article ids

From LemonWiki共筆
Revision as of 10:04, 13 December 2023 by Unknown user (talk) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;