original_reply |
[{"entity": "Mendocino County Mushroom Harvest","summary": "The mushroom harvest in Mendocino County typically occurs in the fall, usually from October to December. Mushroom enthusiasts and foragers will enjoy exploring the county’s forests during this time to discover a wide variety of edible and medicinal mushrooms."}] |
Mendocino County Mushroom Harvest query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%County%Mushroom%Harvest%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Mushroom Harvest’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county mushroom harvest’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mushroom%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Harvest%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Mushroom Harvest’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county mushroom harvest’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Mushroom%’ OR post_title LIKE ‘%Harvest%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Mendocino County Mushroom Harvest |
{"post":"","summary":"The mushroom harvest in Mendocino County typically occurs in the fall, usually from October to December. Mushroom enthusiasts and foragers will enjoy exploring the county’s forests during this time to discover a wide variety of edible and medicinal mushrooms.","permalink":""} |
paragraph |
The mushroom harvest in Mendocino County typically occurs in the fall, usually from October to December. Mushroom enthusiasts and foragers will enjoy exploring the county’s forests during this time to discover a wide variety of edible and medicinal mushrooms.<br><br> |