I want a code like this:
UPDATE `jnkdadb7a_usermeta` SET `meta_key`='x1' WHERE (`meta_key` = 'x2');
I want a SQL command to search inside jnkdadb7a_usermeta table for meta_key (X) and delete it.
Is this what you are looking for?
DELETE FROM jnkdadb7a_usermeta WHERE meta_key='X';