how to delete rows by the id units number please ?

Hello, i wanna delete the rows by the the id units number, i mean i wanna do it like this..."Delete From table Where (id unit number is 2)"
so the command will delete the all rows with 2 in it's id unit number, for example it will delete the rows with the ids like 2, 12, 22, 32, 42, 52,.. 112, 122... etc
so how to delete rows by the units number ? what is the mysql command for that please?
thanks

 

You can use MOD() for this as well.

DELETE FROM table WHERE MOD(id,10)=2;

Code (markup):

 

thanks a lot

 

Does that really remove all id's with a 2 in it ?
I would have tought you needed to do a cast of the INT ->Varchar and then a like (%2% ) operation.

You case is any ID with a 2 in it, so 220 and 3325 are also valid for deletion in your description.

 

DELETE FROM table WHERE to_char(id_unit) like '%2%';