# Where Condition in \_SQL
**URL:** https://discuss.elastic.co/t/where-condition-in-sql/285427
**Category:** Elasticsearch
**Tags:** elastic-stack-sql
**Created:** [September 29, 2021, 4:26am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427 "2021-09-29T04:26:41Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)
#### Post date: [September 29, 2021, 4:26am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/1 "2021-09-29T04:26:41Z")
Hello Team
I am using Elasticsearch version 7.8.0
I am in need of \_SQL ...
```auto
curl -X POST "localhost:9200/_sql?format=txt&pretty" -H 'Content-Type: application/json' -d'
{
"query": "SELECT count(*) FROM \"my-index-000001\" where \"Status\" = 'N' "
}
' -u user:pass
```
This Where condition ='N' is not working ...
I tried multiple things like using "" but its not helping me ...
Could someone please help me ... how to mention same in curl command.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [September 29, 2021, 4:44am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/2 "2021-09-29T04:44:38Z")
Try with `n` instead of `N`.
What's the mapping for this field?
---
### Author:  [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)
#### Post date: [September 29, 2021, 6:20am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/3 "2021-09-29T06:20:05Z")
Hello @dadoonet
```auto
"Status" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
```
Same Error Message :
```auto
{
"error" : {
"root_cause" : [
{
"type" : "verification_exception",
"reason" : "Found 1 problem\nline 1:57: Unknown column [n]"
}
],
"type" : "verification_exception",
"reason" : "Found 1 problem\nline 1:57: Unknown column [n]"
},
"status" : 400
}
```
---
### Author:  [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)
#### Post date: [September 29, 2021, 8:33am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/4 "2021-09-29T08:33:01Z")
> [@tusharnemade](#):
>
> This Where condition ='N' is not working ...
What does this mean? No returned results? An error message?
I suspect the single quoting you're using for curl (`-d'`) is interacting with single quoting within the query (`'N'`). Otherwise, you could leave out the double quoting around `Status`.
Either switch to using double quotes for curl, or use unicode escape for the single quotes (like `Status=\u0027N\u0027`).
In the documentation [examples](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-getting-started.html) there are `Copy as curl` links you can find inspiration in.
---
### Author:  [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)
#### Post date: [September 29, 2021, 9:10am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/5 "2021-09-29T09:10:40Z")
Thank You @bogdan.pintea
Example Page did helped me to understand ..
```auto
curl -X POST "localhost:9200/_sql?format=txt&pretty" -H 'Content-Type: application/json' -d'
{
"query": "SELECT count(*) FROM \"my-index-000001\" where Status = \u0027N\u0027 "
}
'
```
This worked correctly now ...
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 27, 2021, 9:11am UTC](https://discuss.elastic.co/t/where-condition-in-sql/285427/6 "2021-10-27T09:11:11Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.