original_reply |
[{"entity": "The Enchanted Forest","summary": "Nature lovers and families seeking a magical experience will enjoy exploring The Enchanted Forest, located in Mendocino County."}] |
The Enchanted Forest query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Enchanted%Forest%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Enchanted Forest') OR SOUNDEX(post_title) LIKE SOUNDEX('enchanted forest') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Enchanted%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Forest%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Enchanted Forest')OR SOUNDEX(post_title) LIKE SOUNDEX('enchanted forest')OR (post_title LIKE '%Enchanted%' OR post_title LIKE '%Forest%'))HAVING match_count >= 2ORDER BY match_count DESC; |
The Enchanted Forest |
{"post":"","summary":"Nature lovers and families seeking a magical experience will enjoy exploring The Enchanted Forest, located in Mendocino County.","permalink":""} |
paragraph |
Nature lovers and families seeking a magical experience will enjoy exploring The Enchanted Forest, located in Mendocino County.<br><br> |