146 reputation
2
bio website
location
age
visits member for 1 year, 10 months
seen Jan 10 at 0:36

Dec
18
comment Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE
I have done similar thing before and it did not work. This one does not work either. Final SELECT from combined_data as good_score with MATCH() and AGAINST() gives a 0 result. I researched about this issue and found out that NON IN BOOLEAN MODE applies 50% rule, which by its nature somehow ignores results from one table when there is some mathematical relation with 50% of results. Still, thank you for suggestion, but I would like to hear some other ideas. Thanks again.
Dec
17
awarded  Nice Question
Dec
17
awarded  Student
Dec
17
comment mysql index on derived table
Please take a look here, I asked for help at StackOverflow as well. stackoverflow.com/questions/13914087/…
Dec
17
asked Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE
Dec
17
comment mysql index on derived table
I'm making a search. I already tried making a temporary table for this but without fortune; MATCH() AGAINST() on this new table returns zero results because of "50% rule".
Dec
17
comment mysql index on derived table
Okay, columns name and title are indexed as FULLTEXT. I want data to have a FULLTEXT index as well. But there won't be such column as data in phpmyadmin to make it FULLTEXT in traditional way. Question is HOW TO MAKE data indexed as FULLTEXT
Dec
17
comment mysql index on derived table
name and title are fulltext indexes
Dec
17
asked mysql index on derived table