php delete mysql row from id 9809 to id 17275

Question

how to delete mysql row from id 9809 to id 17275?

sql =" DELETE from Table WHERE id = 9809 to id= 17275"

how to delete from the start id to the end id?

[`BETWEEN`](https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#operator_between) — SpazzMarticus, Jan 22 '18 at 08:45

score 3 · Answer 1 · answered Jan 22 '18 at 08:45

3

if you want delete a range of numeric values you could use between

  sql =" DELETE from Table WHERE id between  9809 and  17275"

answered Jan 22 '18 at 08:45

ScaisEdge

score 1 · Answer 2 · answered Jan 22 '18 at 08:47

1

it must be

$sql = " DELETE from Table WHERE id between 9809 and 17275"

answered Jan 22 '18 at 08:47

Haseeb A

score 0 · Answer 3 · answered Jan 22 '18 at 08:51

0

DELETE from Table WHERE cast(id as unsigned) >= 9809 and  cast(id as unsigned)<=17275;

answered Jan 22 '18 at 08:51

Mahesh K S

1

Any explanation on why you're not using BETWEEN (like the existing answers) and why you're casting the id's? – M. Eriksson Jan 22 '18 at 08:57

3 Answers3