| original_reply | [{"entity": "Mendocino","summary": "Mendocino is a charming coastal town known for its stunning ocean views, Victorian architecture, art galleries, and cozy bed and breakfast inns."}, {"entity": "Fort Bragg","summary": "Fort Bragg is a coastal city with beautiful beaches, the famous Glass Beach, Skunk Train rides, and a picturesque downtown area with shops and restaurants."}, {"entity": "Point Arena","summary": "Point Arena is a scenic coastal town with a historic lighthouse, rugged coastline, and opportunities for whale watching and hiking along the cliffs."}] |
| Mendocino query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino’)OR (post_title LIKE ‘%Mendocino%’))HAVING match_count >= 1ORDER BY match_count DESC; |
| Mendocino | {"post":{"ID":"32136","post_title":"Rendezvous Mendocino","match_count":"11"},"summary":"Mendocino is a charming coastal town known for its stunning ocean views, Victorian architecture, art galleries, and cozy bed and breakfast inns.","permalink":"https://www.visitmendocino.com/listing/rendezvous-mendocino/"} |
| Fort Bragg query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Fort%Bragg%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fort%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bragg%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg’)OR (post_title LIKE ‘%Fort%’ OR post_title LIKE ‘%Bragg%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Fort Bragg | {"post":{"ID":"31945","post_title":"Holiday Inn Express Fort Bragg","match_count":"12"},"summary":"Fort Bragg is a coastal city with beautiful beaches, the famous Glass Beach, Skunk Train rides, and a picturesque downtown area with shops and restaurants.","permalink":"https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/"} |
| Point Arena query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Point%Arena%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Point%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Arena%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena’)OR (post_title LIKE ‘%Point%’ OR post_title LIKE ‘%Arena%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Point Arena | {"post":{"ID":"31899","post_title":"Point Arena-Stornetta Public Lands","match_count":"12"},"summary":"Point Arena is a scenic coastal town with a historic lighthouse, rugged coastline, and opportunities for whale watching and hiking along the cliffs.","permalink":"https://www.visitmendocino.com/listing/point-arena-stornetta-public-lands/"} |
| paragraph | <a href="https://www.visitmendocino.com/listing/rendezvous-mendocino/">Mendocino</a> is a charming coastal town known for its stunning ocean views, Victorian architecture, art galleries, and cozy bed and breakfast inns.<br><br><a href="https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/">Fort Bragg</a> is a coastal city with beautiful beaches, the famous Glass Beach, Skunk Train rides, and a picturesque downtown area with shops and restaurants.<br><br><a href="https://www.visitmendocino.com/listing/point-arena-stornetta-public-lands/">Point Arena</a> is a scenic coastal town with a historic lighthouse, rugged coastline, and opportunities for whale watching and hiking along the cliffs.<br><br> |