# Basic search question

**URL:** <https://forum.bubble.io/t/basic-search-question/381612>\
**Category:** Database\
**Created:** [September 25, 2025, 12:27pm UTC](https://forum.bubble.io/t/basic-search-question/381612 "2025-09-25T12:27:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![asked111](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/asked111/32/210876_2.png) [@asked111](https://forum.bubble.io/u/asked111)\
**Post date:** [September 25, 2025, 12:27pm UTC](https://forum.bubble.io/t/basic-search-question/381612/1 "2025-09-25T12:27:15Z")

</div>

I have a table of songs and a table of songwriters.  
A songwriter has a field, “notes”.

My aim is simply to generate a list of songs that shows songwriters that have a certain keywords in their note.

My current search looks like this:

_Do a search for SongWriters (Constraint: Note contains “XYZ”)'s Songs:unique elements_

It works - but it is very slow.

Could someone please tell me if that is the most optimal way to perform this search?

Many thanks

---

<div class="post-metadata">

**Author:** ![boston85719](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/boston85719/32/77286_2.png) [@boston85719](https://forum.bubble.io/u/boston85719)\
**Post date:** [September 26, 2025, 3:58am UTC](https://forum.bubble.io/t/basic-search-question/381612/2 "2025-09-26T03:58:37Z")

</div>

I can not imagine that there is another way, unless you already have a pre-defined list of keywords that might be searched. If you do, you can when the writer adds notes run the search to save to a field the list of keywords it contains, then your search is for that field instead of the note field, making it quicker to find I’d imagine.
