Hi, On Wed, Aug 31, 2016 at 9:14 AM, REGIANY Lucie <[email protected]> wrote: > > HELLO > I WOULD DO SELECT FROM MY TABLE > select * > FROM "_L93_ZONAGES_exportdirectory_list" > WHERE "_L93_ZONAGES_exportdirectory_list".'TYPE' LIKE 'TAB%' > OR > "_L93_ZONAGES_exportdirectory_list".'TYPE' LIKE 'SHP%' > > AND AND SAVE THE RESULT IN A NEW TABLE ZONAGES__SHP_ TAB2016 > > > I WOULD DO SELECT FROM MY TABLE > > select * > FROM "ZONAGES_SHP_TAB2016" > WHERE "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%gare%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%transport%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%CFP%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%tgv%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%intermobilite%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%velo%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%ferre%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%noeud%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%aeroport%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%velo%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%flux%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%deplacement%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%route%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%eurocopter%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%bus%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%Viarhonna%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '% aérien%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%trajet%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%ligne%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%chemin%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%voyageur%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%mobilite%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%interurbain%' > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%navette%' > ; > > I HAVE A ERROR > why please? Help me it's possible
What kind of error do you have? Can you post an error message? Is first query returned any results? BTW, I would create a view based on the first select and then use that view in the second query. Will simplify things a bit. Thank you. > > AND > > AFTER THE SELECT > I WOULD COUNT ON THE FILE FIELD DUPLICATES UP ALSO THE FIELD ID AND DATE OF > CHANGE > > TANK YOU > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
