# How to Delete all entries for a particular coloumn **URL:** \ **Category:** Elasticsearch\ **Created:** [June 23, 2016, 2:04pm UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783 "2016-06-23T14:04:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Rajeev\_Gaurav](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rajeev\_Gaurav](https://discuss.elastic.co/u/Rajeev_Gaurav)\ **Post date:** [June 23, 2016, 2:04pm UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/1 "2016-06-23T14:04:45Z")
Hi, I want to delete all entries for the Date as 2016-02-11. How can I achieve this . I tried DELETE //\_query?q=Date:2016-02-11 but it is giving response as 🙂 { "found": false, "\_index": \<"indexname\>", "\_type": "", "\_id": "\_query", "\_version": 1, "\_shards": { "total": 2, "successful": 2, "failed": 0 } } Kindly help asap. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 23, 2016, 2:49pm UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/2 "2016-06-23T14:49:37Z")
Which version? Did you read [https://www.elastic.co/guide/en/elasticsearch/plugins/current/plugins-delete-by-query.html](https://www.elastic.co/guide/en/elasticsearch/plugins/current/plugins-delete-by-query.html) ? ---
**Author:** ![Rajeev\_Gaurav](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rajeev\_Gaurav](https://discuss.elastic.co/u/Rajeev_Gaurav)\ **Post date:** [June 24, 2016, 5:09am UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/3 "2016-06-24T05:09:51Z")
Elastic search version number is 2.2.1 and lucene\_version is 5.4.1. Yaa I have gone through the link and tried the query DELETE my-index-name/index-mapping-type/\_query?q=Date:2016-02-11. I have doubt about the type(what type it is asking for ) and also can you please tell me the command. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 24, 2016, 5:40am UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/4 "2016-06-24T05:40:27Z")
Where are your data? What is the index name? What is the type? Can you show a Document? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 24, 2016, 5:41am UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/5 "2016-06-24T05:41:50Z")
Also can you share your logs from the restart? ---
**Author:** ![Rajeev\_Gaurav](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rajeev\_Gaurav](https://discuss.elastic.co/u/Rajeev_Gaurav)\ **Post date:** [June 24, 2016, 7:05am UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/6 "2016-06-24T07:05:26Z")
Data is in my local machine. Index name can be anything (mine is :testindex1).I don't have idea about what type means here (I passed my mapping type which is for me :"testmapping"). A document as below: 02/11/2015 12:42:54 PM 2015-02-11 111111111111111111111111111111 2222222222222222222222222222 3333333333333333333333333333 [www.abc.com](http://www.abc.com)[www.abc.com](http://www.abc.com) 7 6 9 7 9 2 2 3 3 5 0 0 0 3 0 xyz 105384 notequal punji face radio ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 24, 2016, 7:26am UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/7 "2016-06-24T07:26:42Z")
This is not a document. A document has fields, values and is in JSON. I'm not sure you know what you are doing. That being said, if your type is `testmapping` you should call: ```auto DELETE testindex1/testmapping/_query?q=Date:2016-02-11 ``` But again, I don't know your mapping and I don't know your docs. Also you did not provide logs so I'm still unsure you installed correctly the plugin. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 10:40pm UTC](https://discuss.elastic.co/t/how-to-delete-all-entries-for-a-particular-coloumn/53783/8 "2017-07-05T22:40:50Z")