[Dean C]

Okie dokie, well I'm too lazy to sit down and write all the regexps myself so I say we form a community collboration on this one

How we'll do this
There are several different types of SQL queries which are passed to the database driver in db_mysql.php. These are (off the top of my head):

• SELECT FROM / DELETE FROM
• UPDATE
• INSERT INTO / REPLACE INTO
• JOIN

So we're probably looking at 4 regexps and a possibly a few more (that I've forgot).

The idea is one person from the community volunteers to take part of a query and rewrite it As we're going to have 4+ different people writing different pieces of code I think all we need to post up for now is an example query taken from vB3 and an example of your regexp fixing your part of the query and echoing it before and after.

My Contribution:

I'll do the FROM part of SELECT and DELETE