Look at the following string:

SELECT
    column1 ,
    column2, column3
FROM
    table1
WHERE
    column1 = 'text, "FROM" \'from\\\' x' AND
    column2 = "sample text 'where' \"where\\\" " AND
    ( column3 = 5 )

I need to escape unnecessary white space characters from the string like:

• removing white space from beginning and ending position of , ( ) etc
• removing newline (\r\n) and tabs (\t)

But one thing. The remove process could not remove white spaces from the quoted string like:

• 'text, "FROM" \'from\\' x'
• "sample text 'where' \"where\\" "

etc.

i need to use the PHP function: preg_replace($pattern, $replacement, $string);

So what will be the value of $pattern and $replacement where the value of $string is the given SQL.