<p>Try to specify the fields you need to search.</p>
<pre><code>{% set queryParams = {
        search: {
            query: 'title:*' ~ name ~ '* OR description:*' ~ name ~ '* OR previewText:*' ~ name ~ '* OR tag:*' ~ name ~ '*'
        }
    } %}

{% set entries = craft.entries(queryParams).section('entries').all() %}
</code></pre>

CC BY-SA 4.0
2020-07-16T07:56:01.370Z
Based on your reply, I tried 
`{% set queryParams = { search: { query: 'title:*' ~ searchQuery ~ '* OR mediaDescription:*' ~ searchQuery ~ '*' } } %}
{% set entries = craft.entries(queryParams).search(searchQuery).section('tv, movies, documentaries').orderBy('score').all() %}` but it's still not returning results.
MarkD
CC BY-SA 4.0
2020-07-16T08:01:45.960Z
But this worked...
`{% set queryParams = { search: { query: 'title:*' ~ searchQuery ~ '* OR mediaDescription:*' ~ searchQuery ~ '*' } } %}
{% set entries = craft.entries(queryParams).section('tv, movie, documentaries').orderBy('score').all() %}`
MarkD
CC BY-SA 4.0
2020-07-16T08:11:20.780Z
@MarkD not returning result, because we call method search, when add it in hash queryParams.
Pavel Pavlovich
CC BY-SA 4.0
2020-07-16T07:28:00.807Z
2020-07-16T07:28:00.807Z
Pavel Pavlovich
<p>&quot;being&quot; is a MyISAM full-text search stopword by default (meaning MySQL will ignore it for full text searches).</p>
<p><a href="https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html</a></p>
<p>If you're on MySQL 5.6+, you can convert Craft's <code>searchindex</code> table to InnoDB (where it's not a stopword), or you can edit your MySQL's config stop word list to exclude that word.</p>

CC BY-SA 4.0
2020-07-17T05:30:53.820Z
2020-07-17T05:30:53.820Z
Brad Bell
<p>I have an entry about the U.K. TV show &quot;Being Human&quot;. If I search &quot;being&quot; on the back end, it comes up with 0 results, same on the front end search.</p>
<p>Searching for &quot;Human&quot; brings it up, but &quot;Being Human&quot; does not.</p>
<p>Doe the default &quot;title&quot; field not get indexed by search? How can I enable it if so?</p>

<search>
Search not searching certain words - how to fix?
# Search not searching certain words - how to fix?

(Asked by: username_0 on 2020-07-16)

I have an entry about the U.K. TV show "Being Human". If I search "being" on the back end, it comes up with 0 results, same on the front end search.

Searching for "Human" brings it up, but "Being Human" does not.

Doe the default "title" field not get indexed by search? How can I enable it if so?

**Tags:** search

---

## 2 answers

### Answer by username_1 on 2020-07-16. Score: 1 | Accepted answer

Try to specify the fields you need to search.
{% set queryParams = {
        search: {
            query: 'title:*' ~ name ~ '* OR description:*' ~ name ~ '* OR previewText:*' ~ name ~ '* OR tag:*' ~ name ~ '*'
        }
    } %}

{% set entries = craft.entries(queryParams).section('entries').all() %}

> **Comments:**
> **username_0**: Based on your reply, I tried  `{% set queryParams = { search: { query: 'title:*' ~ searchQuery ~ '* OR mediaDescription:*' ~ searchQuery ~ '*' } } %} {% set entries = craft.entries(queryParams).search(searchQuery).section('tv, movies, documentaries').orderBy('score').all() %}` but it's still not returning results.  
> **username_0**: But this worked... `{% set queryParams = { search: { query: 'title:*' ~ searchQuery ~ '* OR mediaDescription:*' ~ searchQuery ~ '*' } } %} {% set entries = craft.entries(queryParams).section('tv, movie, documentaries').orderBy('score').all() %}`  
> **username_1**: @MarkD not returning result, because we call method search, when add it in hash queryParams.  

---

### Answer by username_2 on 2020-07-17. Score: 1

"being" is a MyISAM full-text search stopword by default (meaning MySQL will ignore it for full text searches).

<https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html>

If you're on MySQL 5.6+, you can convert Craft's `searchindex` table to InnoDB (where it's not a stopword), or you can edit your MySQL's config stop word list to exclude that word.


---

