분류 전체보기88 MYSQL 다중 검색 명령어 ex) SELECT `joketext` FROM `joke` WHERE `joketext` LIKE "%참%" AND `jokedate` >= "2020-01-01" AND `jokedate` = "2020-01-01" AND `컬럼2` < "2020-07-30"; 2020. 7. 12. MYSQL 특정 텍스트 검색 명령어 ex) SELECT `joketext` FROM `joke` WHERE `joketext` LIKE "%참%"; SELECT `컬럼1` FROM `테이블명` WHERE `컬럼1` LIKE "%검색할단어%"; 2020. 7. 11. MYSQL 특정 요일 row 개수 세기 ex) SELECT COUNT(*) FROM `joke` WHERE `jokedate` >= "2020-01-01"; SELECT COUNT(*) FROM `테이블명` WHERE `날짜컬럼명` >= "2020-01-01"; 2020. 7. 11. MYSQL row 세기 명령어 ex) SELECT COUNT(`id`) FROM `joke`; SELECT COUNT(`컬럼1`) FROM `테이블명`; 2020. 7. 11. 이전 1 2 3 4 5 6 7 ··· 22 다음