Home > Blockchain >  In mysql how to get users that have no event X in past 14 days and neither in the future
In mysql how to get users that have no event X in past 14 days and neither in the future

Time:09-02

Consider I have the following table and current date is 2022-09-01:

enter image description here

Requirement: I want to get all users that have no event_name like cbt care in the past 14 days and onwards into the future.

I have this query:

SELECT * FROM test_table
WHERE event_name LIKE "           
  • Related