mercredi 13 juillet 2016

find duplicate row in mysql command

i have this command to get all post id of my wordpress site :

SELECT post_id 
FROM `wp_postmeta` 
WHERE `meta_key` LIKE 'imdbID'

and i want to get all post id that are NOT in this 3 command :

SELECT post_id 
FROM `wp_postmeta` 
WHERE `meta_key` LIKE '720-link' AND `meta_value` LIKE '%/%'

SELECT post_id 
FROM `wp_postmeta` 
WHERE `meta_key` LIKE 'linkDVD' AND `meta_value` LIKE '%/%'

SELECT ID 
FROM `wp_posts`
WHERE `post_title` LIKE '%سر%' AND `post_status` LIKE 'publish' 
      AND `post_type` LIKE 'post'

how can i find it ?

Aucun commentaire:

Enregistrer un commentaire