Query - MySQL - WordPress | Search Keyword

query_mysql_search_keyword_WP.sql

SELECT 
    p.ID,
    CONCAT(o.option_value, '/', p.post_name, '/') AS post_url
FROM 
    wp_posts p
JOIN 
    wp_options o ON o.option_name = 'siteurl'
WHERE 
    p.post_status = 'publish' 
    AND p.post_type = 'post'
    AND (p.post_title LIKE '%tu_palabra_clave%' OR p.post_content LIKE '%tu_palabra_clave%')
ORDER BY 
    p.post_date DESC
LIMIT 50;