开发者

How do I get a column type "date" inserted into FULLTEXT in a mysql table?

开发者 https://www.devze.com 2022-12-23 00:50 出处:网络
I am making a control panel for administrators on my site that is a search function. When you enter a name it pulls the users first name,last name, email and password. When I tried to insert Birthday

I am making a control panel for administrators on my site that is a search function. When you enter a name it pulls the users first name,last name, email and password. When I tried to insert Birthday into the FULLTEXT to include it in the search, it is not on the drop down. I think because its type is 'date'. Is there a way around that? Also, status is showing up in the drop down but won't display when I put it in the match/search q开发者_开发百科uery. The only difference is that it has a default status of pending.

Thank you


As per the docs:

Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.

0

精彩评论

暂无评论...
验证码 换一张
取 消