# Query syntax, with missing values

**URL:** <https://discuss.elastic.co/t/query-syntax-with-missing-values/14080>\
**Category:** Elasticsearch\
**Created:** [October 24, 2013, 4:40am UTC](https://discuss.elastic.co/t/query-syntax-with-missing-values/14080 "2013-10-24T04:40:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Justin\_MacCarthy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/justin_maccarthy/32/2020_2.png) [@Justin\_MacCarthy](https://discuss.elastic.co/u/Justin_MacCarthy)\
**Post date:** [October 24, 2013, 4:40am UTC](https://discuss.elastic.co/t/query-syntax-with-missing-values/14080/1 "2013-10-24T04:40:28Z")

</div>

Hi newbie question,

how can I search for people whose name begins with j and is under 18 (no  
value in age, assume under 18 )?

## name age

joe 50  
joe 17  
jim 6  
james  
jo 33

I think I need to use the missing filter?

If you can give the curl syntax that would be great !

Thanks

--  
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).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Hendrik](https://avatars.discourse-cdn.com/v4/letter/h/839c29/32.png) [@Hendrik](https://discuss.elastic.co/u/Hendrik)\
**Post date:** [October 24, 2013, 5:46am UTC](https://discuss.elastic.co/t/query-syntax-with-missing-values/14080/2 "2013-10-24T05:46:15Z")

</div>

have a look  
here [Redirecting to Google Groups](https://groups.google.com/forum/?fromgroups=#!topic/elasticsearch/4TiUj7smKUM)

Am Donnerstag, 24. Oktober 2013 06:40:28 UTC+2 schrieb Justin MacCarthy:

> Hi newbie question,
> 
> how can I search for people whose name begins with j and is under 18 (no  
> value in age, assume under 18 )?
> 
> ## name age
> 
> joe 50  
> joe 17  
> jim 6  
> james  
> jo 33
> 
> I think I need to use the missing filter?
> 
> If you can give the curl syntax that would be great !
> 
> Thanks

--  
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).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**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, 2:10am UTC](https://discuss.elastic.co/t/query-syntax-with-missing-values/14080/3 "2017-07-06T02:10:56Z")

</div>

Closed on July 6, 2017, 2:10am UTC