MySQL Forums
Forum List  »  PHP

MySQL FULLTEXT index INT field??? Anyway to trick MySQL?
Posted by: Keith Mundrick
Date: August 04, 2005 09:23AM


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

Options: ReplyQuote

Written By
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.