title: MySQL Fulltext vs Like
body: <p><strong>Background</strong> I have a table with max 2000 rows, the user should search up to 6 columns.<br>
  I don't know in advance what he's looking for and i want a concatenated search (search1 AND search2 AND...)</p>
  
  <p><strong>Problem</strong> In these columns I have the an ID not the plain description (ie i have the id of the town, not its name). So I was thinking about two solutions:</p>
  
  <ol>
  <li>Create another table, where i put keywords (1 key/row) and then i search there using <em>LIKE search1% OR LIKE search2% ...</em></li>
  <li>Add a field to the existent table where I put all the keywords and then do a FULLTEXT on that</li>
  </ol>
  
  <p>Which one is the best? I know that rows are so fews that there won't be big perfomance problems, but i hope they'll get more and more :)</p>
  
  <p><strong>Example</strong><br>
  This is my table: </p>
  
  <p>ID | TOWN | TYPE | ADDRESS |<br>
  11| 14132 |  3 | baker street 220<br>
  13| 45632 | 8 | main street 12</p>
  
  <p>14132 = London<br>
  45632 = New York<br>
  3 = Customer<br>
  8 = Admin</p>
  
  <p>The user typing "London Customer" should find the first row.</p>