title: How can we write mySQL query to extract a particular substring (which is occurring more than 1 times in text) from text?
body: <p>Suppose we have a table named &quot;matters&quot; in this table there are two columns named &quot;id&quot; and &quot;text&quot;</p>
  <p>In-text column suppose this is text -
  &quot;Hey Manager [mention_user: client_1], Hey Manager [mention_user: umbrella_client_1]&quot;</p>
  <p>o/p: clent_1 client_2</p>
  <p>From this text, we have to extract &quot;client_1&quot; and &quot;client_2&quot;</p>
  <p>And these mentioned user numbers can be more i.e. there can be 5 clients tagged also and we have to extract all these 5 mentioned in the text</p>
  <p>And all these we have to do in .SQL file</p>