title: MySql full text search 2 characters
body: <p>I'm using MySQL FullText Index Search on my system and when I search with 3 characters the query works well but when I search with 2 characters the query returns null.</p>
  
  <p>I use this query:</p>
  
  <pre><code>select * 
  from table 
  where MATCH (description) AGAINST ('+gp*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>I already use this command <code>show variables like 'ft%'</code> to get the value of <code>ft_min_word_len</code> and the value is 4. It is strange that with 3 characters the query works.</p>
  
  <p>However i tried to change this value on file /root/.my.cnf. (I use Ubuntu 14.04 and server pilot). I add this to the file:</p>
  
  <pre><code>[mysqld]
  innodb_ft_min_token_size=2
  ft_min_word_len=2
  </code></pre>
  
  <p>Restart the mysql, drop index and create index.</p>
  
  <p>Although when I execute this command again <code>show variables like 'ft%'</code> the value still remains 4.</p>
  
  <p>How do I use mysql full text search with 2 characters?</p>
  
  <p>Any help will be appreciated! </p>