title: MySQL JSON_REMOVE json array
body: <p>I have channels table:</p>
  
  <pre><code>+----+-------------------+---------+
  | id | sort              | bouquet |
  +----+-------------------+---------+
  |  1 | ["1","2","3","4"] | ["1"]   |
  |  2 | ["4"]             | ["4"]   |
  +----+-------------------+---------+
  </code></pre>
  
  <p>And need to remove "2" value from id 1 so i need to get this:</p>
  
  <pre><code>+----+-------------------+---------+
  | id | sort              | bouquet |
  +----+-------------------+---------+
  |  1 | ["1","3","4"]     | ["1"]   |
  +----+-------------------+---------+
  </code></pre>
  
  <p>I try using this query:</p>
  
  <pre><code>SELECT id, sort, bouquet, JSON_REMOVE(sort, '$."2"') FROM channels WHERE id=1;
  </code></pre>
  
  <p>But value is not removed if i use '$[2]' then value is removed but i need to remove by value not index...does anyone knows how to remove from json array specific value?</p>