| original_reply | [{"entity": "Glass Beach","summary": "Nature enthusiasts and beach lovers will be mesmerized by the dazzling display of colorful sea glass at Glass Beach, making it one of the most beautiful places to see in Mendocino County."}] |
| 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 mesmerized by the dazzling display of colorful sea glass at Glass Beach, making it one of the most beautiful places to see in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| paragraph | Nature enthusiasts and beach lovers will be mesmerized by the dazzling display of colorful sea glass at <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, making it one of the most beautiful places to see in Mendocino County.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.