title: How to use CONCAT_WS/GROUP_CONCAT in LIKE Mysql?
body: <p>I am trying to execute below query which says</p>
  
  <pre><code>SELECT t1.name from table t1, t2 WHERE t2.data LIKE(CONCAT_WS(',' DISTINCT(t1.name)))
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>SELECT t1.name from table t1, t2 WHERE t2.data LIKE(GROUP_CONCAT(DISTINCT(t1.name) SEPARATOR ','))
  </code></pre>
  
  <p>Both ways say</p>
  
  <pre><code>#1111 - Invalid use of group function
  </code></pre>