Good burger

original_reply	[{"entity": "Patterson's Pub","summary": "Burger enthusiasts will appreciate the juicy, flavorful burgers served at Patterson's Pub, making it a great option for those craving a delicious burger in Mendocino County."}, {"entity": "Mendocino Cafe","summary": "Food lovers looking for a tasty burger made with locally sourced ingredients should try the burger at Mendocino Cafe in Mendocino County."}]
Patterson's Pub query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Patterson\'s%Pub%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Patterson\'s Pub') OR SOUNDEX(post_title) LIKE SOUNDEX('patterson\'s pub') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Patterson\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pub%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Patterson\'s Pub')OR SOUNDEX(post_title) LIKE SOUNDEX('patterson\'s pub')OR (post_title LIKE '%Patterson\'s%' OR post_title LIKE '%Pub%'))HAVING match_count >= 2ORDER BY match_count DESC;
Patterson's Pub	{"post":{"ID":"31868","post_title":"Patterson's Pub","match_count":"22"},"summary":"Burger enthusiasts will appreciate the juicy, flavorful burgers served at Patterson's Pub, making it a great option for those craving a delicious burger in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/pattersons-pub/"}
Mendocino Cafe query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Cafe%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Cafe') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino cafe') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cafe%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Cafe')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino cafe')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Cafe%'))HAVING match_count >= 2ORDER BY match_count DESC;
Mendocino Cafe	{"post":{"ID":"31872","post_title":"Mendocino Cafu00e9","match_count":"22"},"summary":"Food lovers looking for a tasty burger made with locally sourced ingredients should try the burger at Mendocino Cafe in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/mendocino-cafe/"}
paragraph	Burger enthusiasts will appreciate the juicy, flavorful burgers served at <a href="https://www.visitmendocino.com/listing/pattersons-pub/">Patterson's Pub</a>, making it a great option for those craving a delicious burger in Mendocino County.<br><br>Food lovers looking for a tasty burger made with locally sourced ingredients should try the burger at <a href="https://www.visitmendocino.com/listing/mendocino-cafe/">Mendocino Cafe</a> in Mendocino County.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here