title: selecting where a cell has the same number as the id inside the string
body: <p>here i have a view called commentsTableview that literally selects all of the data from the comments table which is called commentsTable, the replies column is a nested select statement.</p>
  
  <pre><code>+------+-------------------------------------+-------+---------+
  |idview|comments                             |replies|commentOn|
  +------+-------------------------------------+-------+---------+
  |1     |this is a comment                    |0      |content24|
  +------+-------------------------------------+-------+---------+
  |2     |this is a reply to that comment      |0      |comment1 |
  +------+-------------------------------------+-------+---------+
  |3     |this is another reply to that comment|0      |1        |
  +------+-------------------------------------+-------+---------+
  </code></pre>
  
  <p>using this example if i run the query inside the view <code>(select count(*) from commentsTable where commentsTable.commentOn = idview) as replies</code> this will return 1 for the 1st cell because there is one commentedOn cell that is equal to its id. </p>
  
  <p>however how would i select the cell that sais comment1 instead of just 1, keep in mind this is for a view so no variables can be set. im assuming group_concat is the function needed but ive been unable to get it right and concat this concat function doesnt work either <code>(select count(*) from commentsTable where commentsTable.commentOn = concat("comment", id) as replies</code>.</p>