I saw so many similar question with this same error and the solution is altering the table by adding FULLTEXT to the columns.
But now the problem is I'm writing the query to a VIEW instead of an table. So I can't alter the columns as mentioned in the solution the I gone through.
So how can I solve this issue when it queries to a VIEW.
VIEW:
CREATE OR REPLACE VIEW result AS select p.f_name AS fullname,
p.experience AS experience,
group_concat(distinct s.name
order by s.name ASC separator ', ') AS skills,
p.location AS location from (personal p left join
reg r on((p.reg_id = r.id)))
left join prof_skill ps on((r.id = ps.reg_id)) left join skills s
on((ps.skill_id = s.id)) group by r.id ;
FULL-TEXT Query:
SELECT `registration_no`, `location`, `skills`, `fullname`, `experience`, `active`
FROM `result`
LEFT JOIN `review` ON `result`.`registration_no` = `review`.`reg_id` AND
`review`.`active` = 0
WHERE ( MATCH (fullname,experience,skills,location)
AGAINST ('+henna' IN BOOLEAN MODE) )
AND (`result`.`active` =0 ) GROUP BY `registration_no`
Structure:
INDEXES:
