MySQL + ngram/mecab Sample.
Launch the docker container.
Access from a Web browser.
PhpMyAdmin
Try executing a select statement
SELECT *, MATCH(name) AGAINST('第2保育園' IN NATURAL LANGUAGE MODE) as score
FROM nursery_mecab
ORDER BY score DESC;
![screen shot](https://user-images.githubusercontent.com/174922/163512248-ee92374d-3038-4119-86b9-b23320ed5202.png)
SELECT *, MATCH(name) AGAINST('第2保育園' IN NATURAL LANGUAGE MODE) as score
FROM nursery_ngram
ORDER BY score DESC;
![screen shot](https://user-images.githubusercontent.com/174922/163512282-ff069c06-aa29-4d36-b176-eb9e035077a0.png)
SELECT *, MATCH(name_kana, name) AGAINST('太陽の子 さちが丘保育園' IN NATURAL LANGUAGE MODE) as score
FROM nursery_mecab
ORDER BY score DESC;
![screen shot](https://user-images.githubusercontent.com/174922/163511962-84f186c2-b76c-4362-bf71-bd5f07060680.png)
SELECT *, MATCH(name_kana, name) AGAINST('太陽の子 さちが丘保育園' IN NATURAL LANGUAGE MODE) as score
FROM nursery_ngram
ORDER BY score DESC;
![screen shot](https://user-images.githubusercontent.com/174922/163525169-ea4737b6-eadd-405d-a5db-b37b97f9e752.png)