mysql - Confusing regex behavior when combining ` with ( -


To work around 5.1 compatibility issues with a MySQL 5.0, I am trying to change this pattern: < / P>

  key 'brand_id` (`brand_id`) using Beatia   

on:

  key of' brand_id ' Use Beetry (`brand_id`)   

The following regex runs in the Vime: Finds all the events in the problem:

  key. * '\ (. * \) Using BTRE   

Therefore, I tried to modify it only in the lower replacement string, but it can detect matching strings. Why? Using the Beatri / Key \ 1 word (\ 2) / gc

 % s / key (`. * *) / Code>   

I do not know why, but in Vim you can avoid matching boxes and let them alone Try to leave when they should be taken verbally: try

 % s / key (`. * '\) \ ((*. *) \) Beetree Beatree \ / 2 / GC / key \ 1 is using / Urw>  

Comments