SELECT * FROM ( SELECT @row := @row +1 AS rownum, noun FROM ( SELECT @row :=0) r, nouns ) ranked WHERE rownum %4 =1
The table name is ‘nouns’. The column with data we want is ‘noun’.
As you can see from the return, it is working. This table has over 752 rows, but MySQL gave us every 4th: