title: Which searching method with my MYSQL db
body: <p>Im making a (small) site in php &amp; mysql. The mysql database consists of a single table with possibly tens of thousands of rows (in the future).</p>
  
  <p>I only need to get results from one column which has a character limit of 200.</p>
  
  <p>Considering that I don't want any stopwords or "common" word features; and the column contains filenames (some with special characters), what type of search would you recommend?</p>
  
  <p>EDIT: Just some more clarification on filenames:<br>
  I don't want to do an exact match; say I have a name like this: [abc]_random_file.txt; searching for "abc random" OR "[abc] random" OR "abc txt" should all match. Hope that makes sense.</p>
  
  <p>I've considered:</p>
  
  <p>1----SQL like statement<br>
  2----SQL regexps (as shown on this website: <a href="http://www.iamcal.com/publish/articles/php/search/" rel="nofollow">http://www.iamcal.com/publish/articles/php/search/</a> )<br>
  3----Mysql Full-Text Search(MyISAM)<br>
  4----Third party search engines(really don't want to do this)  </p>
  
  <p>With #2 I can probably get the results I want, however I don't think it would work well with my table if it gets big?</p>
  
  <p>Would appreciate any help; im a real beginner to all this and I've been googling all day :(</p>