{"id":234,"date":"2011-05-27T12:03:00","date_gmt":"2011-05-27T12:03:00","guid":{"rendered":"http:\/\/www.sitekickr.com\/blog\/?p=234"},"modified":"2011-05-27T12:03:00","modified_gmt":"2011-05-27T12:03:00","slug":"mysql-full-text-search-relevance-percentage","status":"publish","type":"post","link":"https:\/\/www.sitekickr.com\/blog\/mysql-full-text-search-relevance-percentage\/","title":{"rendered":"MySQL full text search w\/ relevance percentage"},"content":{"rendered":"<p>We&#39;re using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum relevance.<\/p>\n<p><code>SELECT f.faq_question, f.faq_answer,&nbsp; ROUND(((MATCH(faq_question, faq_answer) AGAINST (&#39;mykeyword&#39;)) \/ scores.max_score) * 100) as relevance<br \/>\n\tFROM faq f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp; (SELECT MAX(MATCH(faq_question, faq_answer) AGAINST(&#39;mykeyword&#39;)) as max_score FROM faq LIMIT 1) scores<br \/>\n\tHAVING relevance &gt; 0<br \/>\n\tORDER BY relevance DESC<br \/>\n\t<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#39;re using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[13],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/234"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":1,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"predecessor-version":[{"id":235,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/234\/revisions\/235"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}