How to delete certain rows from MySQL table?

Question

Okay, so my database looks something like this:

MapID

h-1
h-2
s-1
s-2

What I'm trying to do is delete rows where the MapID begins with h, and not the rows that begin with anything else (I have multiple alphabet letters to distinguish which type of data is in that row). How would I go about doing that?

mhawke · Accepted Answer · 2014-12-08 02:18:10Z

2

DELETE FROM map_table where mapid LIKE 'h%';

See documentation for LIKE.

answered Dec 8, 2014 at 2:18

mhawke

87.5k10 gold badges122 silver badges142 bronze badges

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

Comments

John Ruddell · Accepted Answer · 2014-12-08 02:20:46Z

1

if you don't like using like you can use a string function like so

DELETE FROM table WHERE LEFT(MapID , 1) = "h";

this should be faster if you have an index on MapID

DEMO

answered Dec 8, 2014 at 2:20

John Ruddell

25.9k7 gold badges60 silver badges88 bronze badges

Comments

Gordon Linoff · Accepted Answer · 2014-12-08 02:17:43Z

0

You would just do:

delete t from table t
    where t.mapid like 'h%';

answered Dec 8, 2014 at 2:17

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

How to delete certain rows from MySQL table?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related