Originally Posted by
DrJizzle
I thought of trying that.. but I dont know how I would sift out just a third, then grab another third without grabbing any of the same records, then the final third without grab anymore of the same records.
I didn't realize what I posted. I wrote one thing but was thinking another. I guess this would be how to do it, not sure if it'll run but it looks okay.
[CODE="SQL"]
SELECT *
FROM table_a
WHERE (`id` != "31769629-4a63-83b2-de31-49b3a5e72271"
OR `id` != "162541ac-8842-86c9-6fa8-49af50d437e6"
OR `id` != "df61cc92-4af1-6f22-6aa3-4a4a9fd293e6")
LIMIT 0, (SELECT COUNT(*) * 1/3 FROM table_a)
UNION
SELECT *
FROM table_a
WHERE (`id` != "31769629-4a63-83b2-de31-49b3a5e72271"
OR `id` != "162541ac-8842-86c9-6fa8-49af50d437e6"
OR `id` != "df61cc92-4af1-6f22-6aa3-4a4a9fd293e6")
LIMIT (SELECT COUNT(*) * 1/3 FROM table_a), (SELECT COUNT(*) * 2/3 FROM table_a)
UNION
SELECT *
FROM table_a
WHERE (`id` != "31769629-4a63-83b2-de31-49b3a5e72271"
OR `id` != "162541ac-8842-86c9-6fa8-49af50d437e6"
OR `id` != "df61cc92-4af1-6f22-6aa3-4a4a9fd293e6")
LIMIT (SELECT COUNT(*) * 2/3 FROM table_a), (SELECT COUNT(*) FROM table_a)
[/CODE]