I'm using MATCH AGAINST to search in my MySQL database, and on my pc in phpMyAdmin, I type:
ALTER TABLE sites ADD FULLTEXT(Keywords)
to make it FULLTEXT (to allow searching) and it works fine.
On my dedicated server (online), I try the same thing and get:
MySQL said: You have an error in your SQL syntax near '(Keywords)' at line 1
Any ideas?
The Search box on our site relies on this, so the quicker I can sort it the better.
Thanks,
Danny
ALTER TABLE sites ADD FULLTEXT(Keywords)
to make it FULLTEXT (to allow searching) and it works fine.
On my dedicated server (online), I try the same thing and get:
MySQL said: You have an error in your SQL syntax near '(Keywords)' at line 1
Any ideas?
The Search box on our site relies on this, so the quicker I can sort it the better.
Thanks,
Danny