$line =~ s%(?:\p{IsSpace}*) #Match zero or more spaces
(\bNOT)?                    #Match zero or one "NOT" operator(s)
(\(*)                       #Match zero or more left parentheses
(\p{IsSpace}*|\s*|\b|^)     #Match zero+ spaces or a word boundary
(?!\")                      #Ensure this doesn't appear beforehand
((?:\p{IsWord}|\w|`|        #Match zero+ words
(?:\&\p{IsAlnum}*\;)*)*     #Include HTML special chars, e.g. á
(?:\.\{\d+\})*              #Include zero+ MySQL-style wildcard '?'s
(?:\[\.[^\.\]]*\.\])*       #Include zero+ MySQL REGEXP chars
(?:\[\:[^\:\]]*\:\])*       #Include zero+ MySQL REGEXP special chars
(?:\[[^\]]*\])*             #Incl. zero+ MySQL REGEXP special patterns
(?:\*(?!\"))*               #Include zero+ stand-alone asterisks
(?:\%(?!\"))*  )            #Include zero+ stand-alone percent signs
(?:\s*|\p{IsSpace}*)        #Match zero+ spaces
(\)*)                       #Match zero+ right parentheses
(?:\p{IsSpace}|\s)*         #Match zero+ spaces
(["()]*)                    #Match zero+ double quotes or parentheses
(?:\p{IsSpace}*)            #Match zero+ spaces
(                           #(begin group)
  (?:NOT|OR|AND|XOR)*       #Match zero+ operator words
  (?:\p{IsSpace}+|\(+|\p{IsZ}|\Z) #Then one+ spaces OR one+ ")"
                                  #OR end-of-string
)                           #(end group)
                            #AND SUBSTITUTE THE ABOVE WITH THE BELOW
%$2$3$table\.$columnName`$1`$like`"$l$wb$4$we$l"$5$6 $7 %xig;