Splitting of articles by article ids

From LemonWiki共筆
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;