MySQL - Trying to use FULLTEXT search on DATETIME column

by Marc Alexander   Last Updated January 13, 2018 03:06 AM

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

Related Questions

Search functionality using joins

Updated April 27, 2015 23:02 PM

Mysql: does full-text cover normal index?

Updated October 11, 2017 18:06 PM