On 2 Lip, 16:05, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> > EXAMPLE:
> > city_id countrycode languagecode name:
> > 1 fr en Paris
> > 2 fr en Bordeaux
> > 1 fr pl Pary¿
> > 2 fr pl (null OR '')
>
> > countrycode="fr" and languagecode="pl":
> > 2 fr en Bordeaux
> > 1 fr pl Pary¿
>
> > Any ideas?
>
> You said: 'If city_id in languagecode=... not exists, I want fetch THIScity
> in
> languagecode="en"'
>
> But in the example you have given, the city_id 2 with countrycode = "fr" and
> languagecode="pl" DOES exist, and yest you have said that the output should
> ignore it!

Yes, I want ignore rows with empty Name.

In other way, I can delete all rows which have name=="", after I added
data to table.

1.
the city_id 2 with countrycode = "fr" and
languagecode="pl" DOES exist with empty name (name="")

2.
the city_id 2 with countrycode = "fr" and
languagecode="pl" DOESN'T exist

I'm looking for tips.