Lines Matching refs:sql
103 $sql = "UPDATE data_$tbl SET pid = ? WHERE pid = ?";
104 $this->db->query($sql, [$new, $old]);
107 $sql = "UPDATE multi_$tbl SET pid = ? WHERE pid = ?";
108 $this->db->query($sql, [$new, $old]);
121 $sql = "UPDATE schema_assignments SET pid = ? WHERE pid = ?";
122 $this->db->query($sql, [$new, $old]);
136 $sql = "UPDATE titles SET pid = ? WHERE pid = ?";
137 $this->db->query($sql, [$new, $old]);
156 $sql = "UPDATE multi_$table
163 $sql = "UPDATE data_$table
168 $this->db->query($sql, [$old, $new, $old]); // exact match
170 $this->db->query($sql, [$old, $new, "$old#%"]); // match with hashes
173 $this->db->query($sql, [$old, $new, "[\"$old\",%]"]); // match JSON string
175 $this->db->query($sql, [$old, $new, "[\"$old#%\",%]"]); // match JSON string with hash