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? — Rocketq
– Rocketq, Commented May 27, 2015 at 9:41

Viraj Nalawade · Accepted Answer · 2015-05-27 09:39:09Z

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, 2015 at 9:39

answered May 27, 2015 at 9:33

Viraj Nalawade

3,2353 gold badges32 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

naveen goyal · Accepted Answer · 2015-05-27 09:33:23Z

1

delete from tablename where meta_key = 'tel'

answered May 27, 2015 at 9:33

naveen goyal

4,6272 gold badges18 silver badges26 bronze badges

Comments

marijnz0r · Accepted Answer · 2015-05-27 09:33:39Z

1

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

For the future, try and read the docs.

answered May 27, 2015 at 9:33

marijnz0r

93410 silver badges23 bronze badges

Comments

Rocketq · Accepted Answer · 2015-05-27 09:34:57Z

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, 2015 at 9:34

Rocketq

5,84124 gold badges86 silver badges138 bronze badges

Comments

Sachu · Accepted Answer · 2015-05-27 09:49:38Z

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, 2015 at 9:49

answered May 27, 2015 at 9:32

Sachu

7,7549 gold badges59 silver badges101 bronze badges

Collectives™ on Stack Overflow

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

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related