original_reply |
[{"entity": "Charles M. Schulz-Sonoma County Airport (STS)","summary": "Travelers flying to Mendocino County will find convenient access through Charles M. Schulz-Sonoma County Airport (STS), which offers domestic flights and rental car services for easy transportation to the Mendocino coast."}] |
Charles M. Schulz-Sonoma County Airport (STS) query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%Charles%M.%Schulz-Sonoma%County%Airport%(STS)%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Charles M. Schulz-Sonoma County Airport (STS)') OR SOUNDEX(post_title) LIKE SOUNDEX('charles m. schulz-sonoma county airport (sts)') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Charles%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%M.%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Schulz-Sonoma%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%County%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Airport%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%(STS)%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Charles M. Schulz-Sonoma County Airport (STS)')OR SOUNDEX(post_title) LIKE SOUNDEX('charles m. schulz-sonoma county airport (sts)')OR (post_title LIKE '%Charles%' OR post_title LIKE '%M.%' OR post_title LIKE '%Schulz-Sonoma%' OR post_title LIKE '%County%' OR post_title LIKE '%Airport%' OR post_title LIKE '%(STS)%'))HAVING match_count >= 6ORDER BY match_count DESC; |
Charles M. Schulz-Sonoma County Airport (STS) |
{"post":"","summary":"Travelers flying to Mendocino County will find convenient access through Charles M. Schulz-Sonoma County Airport (STS), which offers domestic flights and rental car services for easy transportation to the Mendocino coast.","permalink":""} |
paragraph |
Travelers flying to Mendocino County will find convenient access through Charles M. Schulz-Sonoma County Airport (STS), which offers domestic flights and rental car services for easy transportation to the Mendocino coast.<br><br> |