MYSQL 다중 검색 명령어

ex)

SELECT `joketext` FROM `joke` WHERE
`joketext` LIKE "%참%" AND
`jokedate` >= "2020-01-01" AND
`jokedate` < "2020-07-30";

 

SELECT `컬럼1` FROM `테이블명` WHERE
`컬럼1` LIKE "%참%" AND
`컬럼2` >= "2020-01-01" AND
`컬럼2` < "2020-07-30";