title: Can you check if MySql column contains an array of characters?
body: <p>I am trying to implement a search function that allows the user to search by product tag. The problem is some of the tags are in different formats, like some have spaces and others don't.
  At the moment I'm using <br/><code>WHERE modelNumber LIKE '&quot; + '%' + number + '%' + &quot;';&quot;;</code><br/> This will get me the tag if they only fill in some of the tag name, but this won't work if the tag name includes a space but the user does not enter one. <br/>
  My idea was create a char array with the chars in the search, so I'm wondering if there is a way to check if the SQL column entry contains each character in the way.</p>
  <p>Thanks in advance.</p>