i need to update all the table names in my site to add a prefix to each of them. i want to do the select commands using a regular expression as it will save me a heck of a long time. i need to construct a regular expression with the columns entact. im trying to make the expression select everything until 'FROM' is found but have had no success, any ideas?
regular expression, select mysql statement