Focus on Code

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

In these cases you cannot not find what you’re searching may be. Because database engine thinks that there’s no white spaces in this so this can be word.

So what we do?

We just add white spaces at the end of words like this :

Don’t worry about two char or three char words. Always there can be option in database engine that limits minumum char length on full-text searches.