Technically I'm using mysqli.
In MySQL I tried:
ALTER TABLE products ADD FULLTEXT(created);
Created is a DATETIME column. I also tried to change all Collation's of that table to the same utf8 type but it wouldnt stick. Only changed the vachar in the table.
Is it possible to do a FULLTEXT search on a DATETIME column? (%like% is way too slow).
The error I get is:
1283 - Column 'created' cannot be part of FULLTEXT index