woolyg Posted November 15, 2011 Share Posted November 15, 2011 Hi all, I have a little MySQL question I hope I can get some input on. I'm designing a DB, and one of the tables' fields is going to comprise of a non-unique 10-digit integer. This tabel has the possibility to be huge (millions of rows), and the integer will be one of a couple of fields of the table that will be placed in the WHERE part of a SQL query, exactly matching the string in the field. My question is - assuming the table already has a primary key index, should I use an INT data type for this field, or a VARCHAR data type with a FULLTEXT index for more efficient searching? The number will always be 10 characters - either 10 characters or a zero (0). What would be the best data type to use here? Thanks, WoolyG Link to comment https://forums.phpfreaks.com/topic/251206-int-vs-varchar-w-fulltext/ Share on other sites More sharing options...
fenway Posted November 16, 2011 Share Posted November 16, 2011 If it's a number, store it as INT. Link to comment https://forums.phpfreaks.com/topic/251206-int-vs-varchar-w-fulltext/#findComment-1288569 Share on other sites More sharing options...
woolyg Posted November 16, 2011 Author Share Posted November 16, 2011 Great - done. Thanks Fenway. Link to comment https://forums.phpfreaks.com/topic/251206-int-vs-varchar-w-fulltext/#findComment-1288574 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.