MYSQL query optimisation?


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

This site uses Akismet to reduce spam. Learn how your comment data is processed.