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 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
