Mysql full text search result metadata -


i trying use mysql fulltext search feature. unfortunately documentation not give information getting search result metadata such hit offset, total count, etc. how can achieve this?

mysql not provide metadata search results. can so-called relevance score withe following way:

select id, match (title,body)     against ('tutorial' in natural language mode) score     articles; 

relevance computed based on number of words in row, number of unique words in row, total number of words in collection, , number of documents (rows) contain particular word.

you can bit more information on indexes themselves, see this topic on so


Comments