title: How to use like query on FullText Index Column
body: <p>I have this user table structure.</p>
  <pre><code>    `users` (
        `id` bigint(20),
        `balance` bigint(20),
        `current_parent` bigint(20),
        `parents` varchar(45),
        `role_id` int
      );
  </code></pre>
  <p>There are multiple role hierarchy. I have save all upline role id's comma separated in <code>parents</code> column.</p>
  <p>This is my table sample data.</p>
  <p><a href="https://i.stack.imgur.com/Aatp7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Aatp7.png" alt="enter image description here" /></a></p>
  <p>Example 1: Let's say if want to fetch sum of balance of children of parent id 1.</p>
  <p>Using <code>FIND_IN_SET</code>.</p>
  <pre><code>select sum(balance) from users where FIND_IN_SET(1, parents);
  </code></pre>
  <p>Using <code>LIKE</code></p>
  <pre><code>SELECT sum(balance) FROM `users`
      WHERE parents like '1,%'
         or parents like '%,1,%'
         or parents = 1;
  </code></pre>
  <p>Example 2:
  If the parent id is 2.</p>
  <p>Using <code>FIND_IN_SET</code>.</p>
  <pre><code>select sum(balance) from users where FIND_IN_SET(2, parents);
  </code></pre>
  <p>Using <code>LIKE</code></p>
  <pre><code>SELECT sum(balance) FROM `users`
      WHERE parents like '2,%'
         or parents like '%,2,%'
         or parents = 2;
  </code></pre>
  <p>But above query is taking too much time to execute. Currently user table has 1.5 million records. So I have found solution FULLTEXT search . My question is how can I achieve above query using <code>FullText</code>? or any other solution to improve my query performance.</p>