this post was submitted on 15 Aug 2023
1 points (100.0% liked)

mysql reddit

1 readers
0 users here now

Discussion of MySQL and assistance for MySQL related questions.

founded 1 year ago
MODERATORS
[email protected]
1
Using a column that has multiple values as a list (zerobytes.monster)
submitted 1 year ago by [email protected] to c/[email protected]
0 comments fedilink hide all child comments
 
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

no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here