title: Searching for fields that contains the search term
body: <p>I did some studies on Lucene search queries and searched the internet for answers on how to do this... But couldn't find a method that works and my attempts failed, not returning what I want.</p>
  
  <p>Basically, I've a field on my database, that are IDs concatenated by a comma, these fields are Umbraco document properties.</p>
  
  <p>For instance, let's say I've these entries with these fields: </p>
  
  <p>Entry 1: <strong>relatedContents:</strong> 500,700</p>
  
  <p>Entry 2: <strong>relatedContents:</strong> 500</p>
  
  <p>My search query is for fields that have the value 500, as of now, it only returns Entry 2, but when I use a wildcard term by using the value 500*, it returns both of them. That would be fine, but the problem is when searching something that is not begging of a value. </p>
  
  <p>When I search for 700, it doesn't return the Entry 1 and WildCard searches on Lucene doesn't allow the * to be at the begging of the search term.</p>
  
  <p>It looks like my query is searching for values that has to be exactly like the search term. If there was a way to make a query, in an analogy, like one would use a .Contains() to search a substring in a string it would solve this problem, I think.</p>