regex - Clean-up Mysql update query -


Anyway, can I clean it with regular expressions? It appears and I need to add more.

  Set the location of the location = spaces (replace (replace (replacement (replacement (replacement (replacement (replacement (replacement (replacement (region, 'one', ''), 'two ','              

Create a lookup table with the values ​​of possible area / price pairs.

  Update location, Lookuptable SET location.area = Lookuptable.value WHERE location.area = lookuptable.area    

Comments