I’m trying to just test a query in phpmyadmin before putting into a php script but it is giving me a generic error message and not really helping me, i have tried every possible combination of quotes, still no luck.
I have created a fulltext index and it is correctly built.
the sql statement:
SELECT * MATCH(element1_en) AGAINST ('oxford') AS score FROM AATimeline_pages WHERE MATCH(element1_en) AGAINST ('oxford') ORDER BY score DESC
it’s giving me the 'ole:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL blah blah blah…
Any ideas where i might be going wrong?
