Not being an SQL wiz at all, browsing through the results here, I was unable to find a proper solution, although the problem itself is fairly simple.
An entry in
products may look like this:
id = 1 title = 10
Corresponding entry in
id = 10 language_en = "myProduct"
Where as the number in
products.title contains the id of a corresponding entry in
I want to search
products for a certain title, but those titles are stored in
strings (because of multi-language capacities).
This is what i came up with:
SELECT p.* FROM products p JOIN strings s ON p.title LIKE s.language_en WHERE s.language_en LIKE "myProduct"
Unfortunately, this does not yield any proper results. Obviously i have trouble understanding the concept behind the join, but even reading some articles on the concept does not get me there. It's not my pair of shoes.