# How to use "like" operator in aerospike

**URL:** https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778
**Category:** General Discussion
**Created:** [September 1, 2021, 1:49pm UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778 "2021-09-01T13:49:52Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Heena\_Kalra](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/heena_kalra/32/1723_2.png) [@Heena\_Kalra](https://discuss.aerospike.com/u/Heena_Kalra)
#### Post date: [September 1, 2021, 1:49pm UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778/1 "2021-09-01T13:49:52Z")

</div>

I am trying to build cache invalidation.

---

<div class="post-metadata">

### Author: ![kporter](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/kporter/32/515_2.png) [@kporter](https://discuss.aerospike.com/u/kporter)
#### Post date: [September 1, 2021, 6:05pm UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778/2 "2021-09-01T18:05:30Z")

</div>

Aerospike currently does not have a “like” operator; however, the same operation can be achieved with the [“`cmp_regex`” expression](https://docs.aerospike.com/docs/guide/expressions/comparison/#cmp_regex).

---

<div class="post-metadata">

### Author: ![Heena\_Kalra](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/heena_kalra/32/1723_2.png) [@Heena\_Kalra](https://discuss.aerospike.com/u/Heena_Kalra)
#### Post date: [September 2, 2021, 10:06am UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778/3 "2021-09-02T10:06:43Z")

</div>

Thanks…can it work on keys as well?

---

<div class="post-metadata">

### Author: ![kporter](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/kporter/32/515_2.png) [@kporter](https://discuss.aerospike.com/u/kporter)
#### Post date: [September 2, 2021, 10:48pm UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778/4 "2021-09-02T22:48:23Z")

</div>

Yes, you would use it with the [“`key_str()`”](https://docs.aerospike.com/docs/guide/expressions/storage-data/index.html#key_str) expression.

If used in a filter, the following will return all records with keys containing the string “search\_string”:

```auto
cmp_regex(".*search_string.*", 0, key_str())

```

---

<div class="post-metadata">

### Author: ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/system/32/2274_2.png) [@system](https://discuss.aerospike.com/u/system)
#### Post date: [September 2, 2022, 10:49pm UTC](https://discuss.aerospike.com/t/how-to-use-like-operator-in-aerospike/8778/5 "2022-09-02T22:49:18Z")

</div>

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.