Giuliana De Sio...the sister of singer Teresa(born in Salerno,is the character of many Italian TV-fictions,among which the Piovra 1--1984--and Piovra 2--1986)
Is it necessary to call the episodes 3.1, 3.2 etc, as they are in La Piovra 3? Now it makes an impression, that La Piovra 3 has more seasons.. I think, it should be only ep. 1, 2 etc..
With 3.1 it should be when we will have all Piovras together on the one site
You're probally right. The '3.' can be deleted from the episode field. If we want to adjust this however, I think Antoine better can run a batch conversion, otherwise I have to manually update all vehicles. This also applies to La Piovra 4 where the '4.' can be deleted.
Update TABLE_NAME
SET EPISODE = 1
WHERE EPISODE in ('3.1', '4.1')
AND MOVIE_NAME like La Piovra%
Update TABLE_NAME
SET EPISODE = 2
WHERE EPISODE in ('3.2', '4.2')
AND MOVIE_NAME like La Piovra%
etc.
But that isn't the easiest one... You have to run it a couple of times. I have to look into the more sopisticated statement, that replaces all at once...
Yes, the "etc." is the problem. As it only concerns some movies (2 ?) it will go faster to do it by hand on the site
When I asked SQL, it was for something like "set in the field only the characters after the dot that were in that field"
Hey DIEHARD Soon I'll have an opportunity to buy a DVDs with first 'La Piovra' (1984), but maybe you are interested in make screens from it?! As you already have listed 3 and 4.
Sure I am interested in making screenshots of these, but I have not much free time on my hands these days. So if you would like to make screenshots from it yourself, that is perfectly fine with me aswell...