How is a bilingual search performed?

Question

PHP

In some search engines, for example, when you enter adidas, it finds Adidas.
But there are more complex examples, where not letter for letter.

How do you implement a search in two languages?

Answer 1

This is a search not in two languages, but in one.
You need to first decide on your question, and only then ask it

Answer 2

Well, the problem you're facing is one entry. It is solved, probably, in two ways. Global language change (clumsy, ugly), and here is such an input - a search in two fields of a tuple. One table where names are stored can have several fields with different languages. But this is also an ugly solution. You can normalize the whole thing)