Search code examples
mysqlsqldatabasephpmyadminxampp

Is there any way to shorten this SQL Query

SELECT * FROM userfeedback WHERE
    DATE LIKE '2020-07%' OR
    DATE LIKE '2020-08%' OR
    DATE LIKE '2020-09%' OR
    DATE LIKE '2020-10%' OR
    DATE LIKE '2020-11%' OR
    DATE LIKE '2020-12%' OR
    DATE LIKE '2021-01%' OR
    DATE LIKE '2021-02%' OR
    DATE LIKE '2021-03%' OR
    DATE LIKE '2021-04%' OR
    DATE LIKE '2021-05%' OR
    DATE LIKE '2021-06%';

Note : Here DATE is a column name which is of type Timestamp.

Solution

  • If I understood correctly, you want to retrieve all the data from July 2020 until June 2021. Since you stated that the DATE datatype is timestmap, what you can do is the following:

    SELECT * 
FROM userfeedback 
WHERE 
  DATE >= '2020-07-01' AND
  DATE < '2021-07-01'

    PS: I'd avoid using BETWEEN, since it can give undesired results when using Timestamps.