This is an automated archive.

The original was posted on /r/mysql by /u/boolwizard on 2023-08-15 16:07:20+00:00.

Say I have a column named ‘dates’ that is made up of group_concat dates.

An example of a single row:

2023-01-01, 2023-02-01, 2023-01-01

Is there a way to have that column act as a list?

This is essentially the query i’m trying to figure out:

SELECT * FROM table WHERE ‘2023-01-01’ NOT IN dates