How does full-text search work?

Full-text search finds data according to the keyword you entered. However, it cannot find a query term appearing in the middle section of a word.

For example, if you have a product code “CODE1234”, you will not be able to find the record if you only enter ”1234” in the search engine since “1234” is a query term appearing in the middle section of "CODE1234".