title: Fulltext search with mysql ignoring # character
body: <p>I wrote a simple diary/journal online application at personaldreamjournal.com. You can login in demo mode to test it using name guest and password user. </p>
  
  <p>It uses the LIKE to do fulltext searching on words in the diary. I wanted to add the ability to allow hashtags for easy tagging of entries. like if someone enters #workout, it returns all the entries with hashtag #workout. But evidently not that easy as it appears to ignore the hashtag. (no idea why they would ignore ANY character in a text box??, but so is life). </p>
  
  <p>So all entries with the word workout is returned as # is ignored. 
  I just want confirmation, from what I have searched so far, as nothing specifically mentions the # character. </p>
  
  <p>So im assuming # is a special character that is ignored for some reason?
  and that for me to change it I have to alter the MYSQL configuration somewhere? Where exactly for the # character?</p>
  
  <p>Any help confirming what im saying is true, and how to allow for the #character to be counted in return results, is appreciated. </p>
  
  <p>UPDATE:
  below is the actual code I was using. so I wasn't using LIKE</p>
  
  <pre><code>  $query_Recordset1 = "SELECT *, MATCH(`scroll`.text) AGAINST (+'$searchstring_Recordset1'     IN BOOLEAN MODE) AS score FROM scroll WHERE MATCH(`scroll`.text) AGAINST('+$searchstring_Recordset1' IN BOOLEAN MODE) having score &gt; 0.2 AND user = '$username' ORDER BY score DESC";
  </code></pre>