WordPress Permalink Manager Plugin: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 34: | Line 34: | ||
recent-history/attachment/salton-sea-stuck-boat-high-res-no-rv-not-as-vivid22 | recent-history/attachment/salton-sea-stuck-boat-high-res-no-rv-not-as-vivid22 | ||
<br /><syntaxhighlight lang="text"> | |||
one to many | |||
SELECT * FROM wp_posts WHERE post_date='1999-09-13*'; | |||
SELECT * FROM wp_posts WHERE post_date LIKE '1999-09-13%'; | |||
This works to display: SELECT ID FROM wp_posts WHERE post_date LIKE '1999-09-13%'; | |||
This works to insert into another table (clear the TT2 table first) | |||
INSERT INTO TT2 (ID, post_date) | |||
SELECT ID, post_date | |||
FROM wp_posts | |||
WHERE post_date LIKE '1999-09-13%'; | |||
SELECT * FROM wp_postmeta WHERE post_id = '2799'; | |||
SELECT * FROM wp_postmeta WHERE post_id = (SELECT ID FROM TT2 WHERE ID = '2799'); | |||
SELECT * FROM wp_postmeta WHERE post_id = (SELECT ID FROM TT2 WHERE ID = ?); | |||
SELECT * FROM wp_postmeta WHERE post_id = (SELECT ID FROM TT2 WHERE ID LIKE '%'); | |||
SELECT * | |||
FROM wp_posts | |||
INNER JOIN wp_postmeta | |||
ON wp_posts.ID = wp_postmeta.post_id | |||
WHERE post_date LIKE '1999-09-13%'; | |||
SELECT * | |||
FROM wp_postmeta | |||
INNER JOIN wp_posts | |||
ON wp_posts.ID = wp_postmeta.post_id | |||
WHERE wp_posts.post_date LIKE '1999-09-13%'; | |||
set autocommit=0; | |||
COMMIT; | |||
# or if you want to reset changes | |||
ROLLBACK; | |||
</syntaxhighlight> | |||