1. keyword 검색

SELECT *
FROM wp_posts
WHERE post_content LIKE '%keyword%';

SELECT *
FROM in_posts
WHERE post_title LIKE '%고객문의%';

2. 특정  포스트 ID 조회

SELECT *
FROM wp_posts
WHERE ID = 196;

SELECT *
FROM wp_postmeta
WHERE post_id = 935;

3. 특정 포스트 ID 삭제

DELETE FROM wp_posts
WHERE ID = 2079;

DELETE FROM wp_postmeta
WHERE post_id = 2079;

4. 특정 칼럼 제외하고 모두 삭제

DELETE FROM `wp_usermeta`
WHERE NOT (user_id = 1);