The situation is this - there is an Internet store of nuts
You need to use third party search to look for parts of words
For example, the customer enters in the search "Pine" - the result is "nothing found"
But if you type "cedars" - that everyone finds
Search code -
SELECT `name` FROM `table` WHERE `name` LIKE '%cedar%'
The question is - is there any possibility in SQL to search for partial words?