prettiest beach

original_reply	[{"entity": "Glass Beach","summary": "Nature enthusiasts and beach lovers will be captivated by the unique beauty of Glass Beach, known for its colorful sea glass created from years of discarded glass transformed by the ocean waves."}, {"entity": "Mendocino Headlands State Park","summary": "For those seeking stunning coastal views and serene beaches, Mendocino Headlands State Park offers picturesque cliffs, hidden coves, and peaceful tide pools to explore."}]
Glass Beach query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Glass%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Glass Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('glass beach') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Glass%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beach%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Glass Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('glass beach')OR (post_title LIKE '%Glass%' OR post_title LIKE '%Beach%'))HAVING match_count >= 2ORDER BY match_count DESC;
Glass Beach	{"post":{"ID":"31801","post_title":"Glass Beach","match_count":"22"},"summary":"Nature enthusiasts and beach lovers will be captivated by the unique beauty of Glass Beach, known for its colorful sea glass created from years of discarded glass transformed by the ocean waves.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"}
Mendocino Headlands State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Headlands%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Headlands State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino headlands state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Headlands%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Headlands State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino headlands state park')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Headlands%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC;
Mendocino Headlands State Park	{"post":{"ID":"31563","post_title":"Mendocino Headlands State Park","match_count":"24"},"summary":"For those seeking stunning coastal views and serene beaches, Mendocino Headlands State Park offers picturesque cliffs, hidden coves, and peaceful tide pools to explore.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"}
paragraph	Nature enthusiasts and beach lovers will be captivated by the unique beauty of <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, known for its colorful sea glass created from years of discarded glass transformed by the ocean waves.<br><br>For those seeking stunning coastal views and serene beaches, <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a> offers picturesque cliffs, hidden coves, and peaceful tide pools to explore.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here