I tried running your query like this [note my database prefix is 'jml3_'] SELECT * FROM `jml3_k2_items` SET `metadata` = 'robots=author=' WHERE `metadata` = '{"robots":"","author":"","rights":"","xreference":""}' but I got the following message: #1064 - You have an error...