<?php $string = 'SELECT * FROM site_customers LEFT JOIN site_products'; $pattern = '/SELECT \* FROM (\bsite_[a-zA-Z0-9]*) LEFT JOIN (\bsite_[a-zA-Z0-9]*)/'; $replacement = 'SELECT * FROM $1_02 LEFT JOIN new_$2'; echo preg_replace($pattern, $replacement, $string);
You have javascript disabled. You will not be able to edit any code.