Code: Select all
Problem with the query: SELECT *, MATCH(company_name, search_data) AGAINST('%00000001%') AS score FROM adverts WHERE MATCH(company_name, search_data) AGAINST('%00000001%') LIMIT 1, 500
Can't find FULLTEXT index matching the column list