Fluoresce Posted November 5, 2014 Share Posted November 5, 2014 I present videos on my site. The videos (their titles, descriptions, etc.) are stored in a MySQL database.I want visitors to be able to search my database for videos.My MySQL version is 5.5.40-36.1.The storage engine of my tables is INNODB.The two columns I want searched are: title (varchar; unique index) description (text; no index) According to my research, the best way to allow users to search my database would be to use FULLTEXT, but my INNODB tables are incompatible. FULLTEXT is available for INNODB in MySQL 5.6.4 and above.I would rather not use LIKE '%...%', and I would rather not use a third party solution such as Sphinx because my database will never grow particularly large (I doubt it'll ever exceed 6,000–8,000 videos).What do you guys recommend? Is it okay to use LIKE with a database containing 6,000–8,000 items? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.