This gets closer, but still not what I want 1. I have the content in the field

Transcript

holding value

sdfihasdu7iu78823uysdhjjhkhjkjhk etc etc more content here

2. If I do hybrid search for

sdfihasdu7iu78823uysdhjjhkhjkjhk

it finds contents that have very similar "dummy" content like

sadfsdfsd

3. If I do just query the Field

Transcript

it returns 0 results (presumably because now it is looking for an exact match?) 4. If I do only embedding, it finds all sorts of largerly unrelated content. Note that the

Transcript

field is included in my vector embedding, along with other content. It appears the Hybrid gets me close, but not close enough: the actual "correct" results is still not returned. Is what I try to achieve even possible? The goal is that a search returns results that are a "match" as close as possible, but yes of course also "related" results. The thing is, to test that I need it to find an actual unique value. I am working in WP and there, it is a pretty simple query that will find that document immediately if queried

sdfihasdu7iu78823uysdhjjhkhjkjhk

even if this unique string is part of a larger string. Basically I guess I am looking for a LIKE %...% query with semantic query on top.