MYSQL 데이터 수정

ex) 

UPDATE `joke` SET `jokedate` = "2020-06-01" WHERE id="1";

 

UPDATE `테이블명` SET `컬럼` = "바꿀내용" WHERE id="1";

 

ex)

UPDATE `joke` SET `jokedate` = "2020-06-30" WHERE `joketext` LIKE "%참%";

 

UPDATE `테이블명` SET `컬럼1` = "2020-06-30" WHERE `컬럼2` LIKE "%참%";