title: How to Concat results without duplicates when using "Like"
body: <p>I'm attempting to adapt the following query so that in Concats the results without any duplicates.</p>
  
  <pre><code>SELECT `increment_id`
  FROM `sales_order`
  WHERE `remote_ip`
  LIKE '123.123.123.123'
  </code></pre>
  
  <p>Based on <a href="https://stackoverflow.com/questions/276927/can-i-concatenate-multiple-mysql-rows-into-one-field">this post</a>, I have adapted the query to the following:</p>
  
  <pre><code>SELECT `remote_ip`, GROUP_CONCAT(DISTINCT `increment_id` SEPARATOR ', ')
  FROM `sales_order`
  GROUP BY `remote_ip`
  </code></pre>
  
  <p>However, I'm struggling to find a place to add <code>LIKE '123.123.123.123'</code> without causing an error.</p>