I know there are a lot of answers for this on StackOverflow, but my problem is wayyy different.
I have a table called 'listing' in which I have a column called 'listing_tags' where I am running this query:
SELECT *, MATCH(listing_tags) AGAINST ('+ac' IN BOOLEAN MODE) * 10 as rel1
FROM listing
WHERE MATCH (`listing_tags`) AGAINST ('+ac' IN BOOLEAN MODE)
ORDER BY rel1 DESC
LIMIT 30;
Note: My Table engine is InnoDB, I have FULLTEXT Indexing turned on in the listing_tags column, and the search returns no results, whereas when I search the same keyword with LIKE '%ac%', it returns 96 rows out of the total 484 rows in my table.
I have been trying to figure it out for two days, and I have not been able to. I have directly copied the code from the internet, and followed along with all the steps. I still cannot get this to work.
