Ver original$patron = "/.+(from)\s(\w+)(\swhere\s.+)?/i";$coincidencia = 'SELECT COUNT(*) as cont FROM \\2 \\3';$consulta = preg_replace($patron,$coincidencia,$_pagi_sql);