original_reply |
[{"entity": "Mendocino Coast District Hospital","summary": "Those seeking medical care in Mendocino County will appreciate the comprehensive services and compassionate care provided by Mendocino Coast District Hospital."}] |
Mendocino Coast District Hospital query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%District%Hospital%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast District Hospital') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast district hospital') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%District%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Hospital%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast District Hospital')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast district hospital')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%District%' OR post_title LIKE '%Hospital%'))HAVING match_count >= 4ORDER BY match_count DESC; |
Mendocino Coast District Hospital |
{"post":"","summary":"Those seeking medical care in Mendocino County will appreciate the comprehensive services and compassionate care provided by Mendocino Coast District Hospital.","permalink":""} |
paragraph |
Those seeking medical care in Mendocino County will appreciate the comprehensive services and compassionate care provided by Mendocino Coast District Hospital.<br><br> |