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";
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";
댓글