Say I want all restaurants that contain sushi
My user search for sus, ush, and shi
Now I want mysql to efficiently find rows whose title or description (or whatever) contain sus, ush, and shi, including sushi.
What should I do?
Note: Is mysql even suitable for this? It's basically like google autocomplete