Question: I have the following records in a database table

```
ID   NAME         REF
-----------------------
1    ar.chik       33
4    ar.chik.rt    33
5    dy.i.op       35
9    dy.i

```

Which statement can remove the following records:

```
ID   NAME         REF
------------------------
4    ar.chik.rt    33
5    d.yi.op       35

```

Answer: 
If I understanded what You want, You can Use this: 

```
DELETE FROM Yourtable WHERE name='ar.chik.rt' OR name='d.yi.op' ;

```

or

```
DELETE FROM Yourtable WHERE name IN ('ar.chik.rt','d.yi.op') ;

```

Or if You want to remove the records with multiple dots:

```
DELETE FROM Yourtable WHERE name LIKE '%.%.%' ;

```
```
delete from Yourtable 
where id in(4,5);

```