Linea21

SQL query : SELECT project_id, project_name, DATE_FORMAT(project_published_date, '%d-%m-%Y') AS date_display, project_statut AS statut, MATCH(project_name,project_goal,project_description,project_body,project_comment,project_budget_comment, project_elected, project_team) AGAINST(';Bg@dgwCrbTI:KqO') AS pertinence FROM l21_project WHERE MATCH (project_name,project_goal,project_description,project_body,project_comment,project_budget_comment, project_elected, project_team) AGAINST (';Bg@dgwCrbTI:KqO' IN BOOLEAN MODE) AND project_statut<>'E' AND project_statut<>'AA' AND project_statut<>'D' ORDER BY pertinence DESC;

See also : https://stackoverflow.com/questions/25088183/mysql-fulltext-search-with-symbol-produces-error-syntax-error-unexpected