Hi all, I am trying to retrieve multilingual information from a table but I don't know how to do this query.
I have a table defined as: CREATE TABLE table2 (id integer, language text, title text, primary key (id, language)); With this content: id language title ---------- ---------- ------------------ 1 spanish Titulo en español 1 english Title in english 1 polish khkeuh kfjhsy kh 2 english Title 2 english 3 polish jdfhahf hdhf 4 spanish Titulo 4 spanish 5 spanish Titulo 5 spanish 5 russian aaaaaaaaaa What I want to retrieve are the rows with "spanish" titles or if there is no spanish title available, select the title in the first language found. I mean: id language title ---------- ---------- ------------------ 1 spanish Titulo en español 2 english Title 2 english 3 polish jdfhahf hdhf 4 spanish Titulo 4 spanish 5 spanish Titulo 5 spanish _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
