- or download this
$query =~ s/[\n\r\f]+/ /g;
- or download this
$query =~ s/(["']).*?\1/S/g;
- or download this
$query =~ s/"[^"]*"/S/g;
$query =~ s/'[^']*'/S/g;
- or download this
$query =~ s{
\b(in|values?)\s*\(\s*([NS])\s*,[^\)]*\)
}
{$1($2+)}gx;
- or download this
$query =~ s{
\b(in|values?) *\( *([NS]) *,[^\)]*\)
}
{$1($2+)}gx;