| original_reply | [{"entity": "Red Fox Casino","summary": "Red Fox Casino is a great option for those looking for a fun and entertaining gaming experience in Mendocino County."}] |
| Red Fox Casino query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Red%Fox%Casino%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Red Fox Casino’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘red fox casino’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Red%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fox%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Casino%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Red Fox Casino’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘red fox casino’)OR (post_title LIKE ‘%Red%’ OR post_title LIKE ‘%Fox%’ OR post_title LIKE ‘%Casino%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Red Fox Casino | {"post":{"ID":"31816","post_title":"Red Fox Casino","match_count":"23"},"summary":"Red Fox Casino is a great option for those looking for a fun and entertaining gaming experience in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/red-fox-casino/"} |
| paragraph | <a href="https://www.visitmendocino.com/listing/red-fox-casino/">Red Fox Casino</a> is a great option for those looking for a fun and entertaining gaming experience in Mendocino County.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.