MYSQL query optimisation?

Table:

id | title | lang

1 | Moscow | en
1 | Москва | ru
2 | Helsinki | en
2 | Хельсинки | ru

Question is simple – how to efficiently select the ru title by english title?
Now I get the id of the entry first and then make another query by lang. Any other more elegant solutions?


Source: sql

Leave a Reply