Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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';
Required, but never shown