MySQL: delete table rows if string in cell is matched?

Question

I have a table with a column meta_key … I want to delete all rows in my table where meta_key matches some string.

enter image description here

For instance I want to delete all 3 rows with "tel" in it - nut just the cell but the entire row. How can I do that with a mysql statement?

possible duplicate of [how to delete certain row from mysql table?](http://stackoverflow.com/questions/18378190/how-to-delete-certain-row-from-mysql-table) — Rocketq, May 27 '15 at 09:41

Viraj Nalawade · Accepted Answer · 2015-05-27T09:39:09.997

5

The below query deletes the row with strings contains "tel" in it :

   DELETE FROM my_table WHERE meta_key like '%tel%';

This is part of Pattern matching.

If you want the meta_key string to be equal to "tel" then you can try below:

   DELETE FROM my_table WHERE meta_key = 'tel'

This is a simple Delete

edited May 27 '15 at 09:39

answered May 27 '15 at 09:33

Viraj Nalawade

Sachu · Answer 2 · 2015-05-27T09:49:38.437

1

DELETE FROM table WHERE meta_key = 'tel' //will delete exact match

DELETE FROM table WHERE meta_key = '%tel%'//will delete string contain tel

edited May 27 '15 at 09:49

answered May 27 '15 at 09:32

Sachu

score 1 · Answer 3 · answered May 27 '15 at 09:33

1

delete from tablename where meta_key = 'tel'

answered May 27 '15 at 09:33

naveen goyal

score 1 · Answer 4 · answered May 27 '15 at 09:33

1

DELETE FROM `table_name` WHERE meta_key = "tel";

For the future, try and read the docs.

answered May 27 '15 at 09:33

marijnz0r

score 1 · Answer 5 · answered May 27 '15 at 09:34

1

DELETE FROM table
        WHERE meta_key= 'tel';

In addition you can use limit to specify the amount of rows to delete

answered May 27 '15 at 09:34

Rocketq

5 Answers5