title: Confusing regex behavior when combining ` with (
body: <p>In order to work around a mysql 5.0 to 5.1 compatibility issue, I'm trying to change this pattern:</p>
  
  <pre><code>KEY `brand_id` (`brand_id`) USING BTREE
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>KEY `brand_id` USING BTREE (`brand_id`)
  </code></pre>
  
  <p>Running the following regex in vim locates all the occurrences of the issue:</p>
  
  <pre><code>KEY `.*` \(.*\) USING BTREE
  </code></pre>
  
  <p>So, I tried just modifying this to the following substitution string, but it can no longer locate the matching strings.  Why?</p>
  
  <pre><code>%s/KEY (`.*`) (\(.*\)) USING BTREE/KEY \1 USING BTREE (\2)/gc
  </code></pre>