function_getRegexReplaceRows($columnIndex, $find, $replaceWith, $charSet) { $column = $this->_columnNames[$columnIndex]; $sql_query = "SELECT " . PMA_Util::backquote($column) . "," . " 1,"// to add an extra column that will have replaced value . " COUNT(*)" . " FROM " . PMA_Util::backquote($this->_db) . "." . PMA_Util::backquote($this->_table) . " WHERE " . PMA_Util::backquote($column) . " RLIKE '" . PMA_Util::sqlAddSlashes($find) . "' COLLATE " . $charSet . "_bin"; // here we // change the collation of the 2nd operand to a case sensitive // binary collation to make sure that the comparison is case sensitive $sql_query .= " GROUP BY " . PMA_Util::backquote($column) . " ORDER BY " . PMA_Util::backquote($column) . " ASC";