# Restore fails - could not create unique index

**URL:** <https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380>\
**Category:** Self-hosting\
**Created:** [13 mei 2020 om 20:29 UTC](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380 "2020-05-13T20:29:04Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![gerhard](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gerhard/32/119479_2.png) [@gerhard](https://meta.discourse.org/u/gerhard)\
**Post date:** [16 mei 2020 om 14:48 UTC](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380/11 "2020-05-16T14:48:53Z")

</div>

You need to use `LIKE` in order for wildcards to work:

```ruby
IncomingReferer.where("path LIKE '%/m/search%'")

```

---

_[View the full topic](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380)._
