# How to Extract values from bin

**URL:** <https://discuss.aerospike.com/t/how-to-extract-values-from-bin/3875>\
**Category:** General Discussion\
**Created:** [February 23, 2017, 12:56pm UTC](https://discuss.aerospike.com/t/how-to-extract-values-from-bin/3875 "2017-02-23T12:56:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mayank\_Grover](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@Mayank\_Grover](https://discuss.aerospike.com/u/Mayank_Grover)\
**Post date:** [February 23, 2017, 12:56pm UTC](https://discuss.aerospike.com/t/how-to-extract-values-from-bin/3875/1 "2017-02-23T12:56:27Z")

</div>

Hi,

I have a properties bin in my Aerospike DB and on doing a select, i get the following output - aql\> select properties from dsclocal.TPASystem ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | properties | ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | LIST('[{“name”:“Sy OCS Realm”, “value”:“”, “attribute”:1}, {“name”:“Non-Managed Delivery Retry Frequency (secs)”, “application”:“Notification Server”, “value”:“10”, “attribute”:1}, {“name”:“Managed Delivery Retry Count”, “application”:"Notification Serve | ±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.072 secs)

Is there a way to fetch the value(10) of “Non-Managed Delivery Retry Frequency (secs)” record present in the properties bin?

Something like - select from properties where name=“Non-Managed Delivery Retry Frequency (secs)” ??

~Mayank
