title: HiveQL - String contains equivalent in hiveql UDF?
body: <p>I would like to use hiveql UDF to check whether the string contains any specific character or not?</p>
  
  <p>I came across the below one.</p>
  
  <pre><code>find_in_set(str, strlist)
  </code></pre>
  
  <p>Is this the correct UDF to use?</p>
  
  <p><strong>For example:</strong></p>
  
  <p>the below column contains "1" in the value.</p>
  
  <pre><code>column1 = "test1String"
  </code></pre>
  
  <p>i need to write a HiveQL where condition to return the rows with column1 value contains 1.</p>