# Problem with SQL Query with special character in field and table name

**URL:** <https://discuss.elastic.co/t/problem-with-sql-query-with-special-character-in-field-and-table-name/146359>\
**Category:** Elasticsearch\
**Created:** [August 28, 2018, 1:40pm UTC](https://discuss.elastic.co/t/problem-with-sql-query-with-special-character-in-field-and-table-name/146359 "2018-08-28T13:40:19Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![NerdSec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nerdsec/32/22056_2.png) [@NerdSec](https://discuss.elastic.co/u/NerdSec)\
**Post date:** [August 29, 2018, 7:26am UTC](https://discuss.elastic.co/t/problem-with-sql-query-with-special-character-in-field-and-table-name/146359/4 "2018-08-29T07:26:32Z")

</div>

OK. Got it to work. Andrei was right, you will have to escape it. I ran this on the console as follows:

```auto
POST _xpack/sql
{
  "query": "select \"@timestamp\" from \"my-alarms-2018.08.28\""
}

```

Apparently, you had to escape the double quotes. 😄

---

_[View the full topic](https://discuss.elastic.co/t/problem-with-sql-query-with-special-character-in-field-and-table-name/146359)._