title: MySQL Query - How to Filter on One Condition for Multiple Columns
body: <p>I'm looking for a way to make the following query cleaner and more succinct. In my where clause, I am filtering on two dates columns that meet the same condition.</p>
  <pre><code>select * 
  from table 
  where (colA between '2021-04-01' and '2021-04-03') # same date condition
  or (colB between '2021-04-01' and '2021-04-03') # same date condition
  </code></pre>
  <p>Is there a more elegant way to do this?</p>