# Set \_score field value in Elasticsearch **URL:** \ **Category:** Elasticsearch\ **Created:** [October 17, 2014, 1:35pm UTC](https://discuss.elastic.co/t/set--score-field-value-in-elasticsearch/20305 "2014-10-17T13:35:14Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Kruti\_Shukla](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Kruti\_Shukla](https://discuss.elastic.co/u/Kruti_Shukla)\ **Post date:** [October 17, 2014, 1:35pm UTC](https://discuss.elastic.co/t/set--score-field-value-in-elasticsearch/20305/1 "2014-10-17T13:35:14Z")
Hello All, I'm trying achieve one functionality in Elasticsearch but I'm not able to do it. In SQL we can do it like --\> select SET score\_1 = \_score from sometable I trying to assign value of score in one field. That means Elastic search will return 2 columns having same values \_score and \_score1. I have already tried custom score but it changes the value of \_score column it self.I DO NOT WANT TO CHANGE . I'm already happy with the score returned in "\_score" field. I want to have same value of "\_score" column in another column for example "score\_1". I want to do same in Elasticsearch. Is it possible? Is there any functionality provided in elasticsearch? -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/59487bae-f12b-42dd-b193-71422f48fcce%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/59487bae-f12b-42dd-b193-71422f48fcce%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:55am UTC](https://discuss.elastic.co/t/set--score-field-value-in-elasticsearch/20305/2 "2017-07-06T00:55:29Z")