MySQL FULLTEXT index INT field??? Anyway to trick MySQL?
Hello,
I'm writing a PHP search engine to run a FULLTEXT search on my database, and I have it working fine. However, I absolutely need to be able to get the case numbers for my results. These fields are auto-incremented INT fields, however, and MySQL FULLTEXT is only able to index VARCHAR and TEXT fields.
Does anyone have any ideas on how to get around this so that I can grab the numbers? I'm able to pull out everything else from my database, so maybe I can query it again matching all the stuff up? I am really unsure how to go about this, but I'm sure others must have this problem. Everything has a number in online retailers and stuff. I'd like to hear some ideas!
Thanks in advance.
-Keith Mundrick
Crazy IT Guy
Subject
Written By
Posted
MySQL FULLTEXT index INT field??? Anyway to trick MySQL?
August 04, 2005 09:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.