species list clean up

gistfile1.txt

update species_list set is_private=true WHERE list_name REGEXP '^[0-9]' and list_type='OTHER' and is_authoritative is null;
update species_list set is_private=true WHERE list_name REGEXP '^[0-9]' and list_type='SPATIAL_PORTAL' and is_authoritative is null;
update species_list set is_private=true WHERE list_name like 'My species list%' and list_type='OTHER' and is_authoritative is null;
update species_list set is_private=true WHERE list_name = 'My species list' and list_type='SPATIAL_PORTAL' and is_authoritative is null;
update species_list set is_private=true WHERE list_name like 'My species list%' and list_type='SPATIAL_PORTAL' and is_authoritative is null;
update species_list set is_private=true WHERE list_name = 'My species list' and is_authoritative is null;
update species_list set is_private=true 
WHERE 
( list_name like 'My species list%' 
  OR list_name = 'My species list'
  OR list_name like 'Assign%' 	
  OR list_name like 'Area%' 	
  OR list_name like 'BB%' 
  OR list_name like 'big list' 
  OR list_name like 'big list' 
  OR list_name like 'Collinsville'   
  OR list_name like 'data.csv'   
  OR list_name like 'EC_Species'   
  OR list_name like 'fuck'     
  OR list_name like 'robina %'  
  OR list_name like 'species.csv'  
  OR list_name like '0662409'  
  OR list_name like 'ALA List.csv'  
  OR list_name like 'ALA species list.xlsx'  
  OR list_name like 'Brett%'    
  OR list_name like 'bSpecies'   
  OR list_name like 'CLUSTER 3' 
  OR list_name like 'mylist' 
  OR list_name like 'My_species_list'         
  OR list_name like 'M_ZMy species list'           
  OR list_name like 'Number of endemic species 0606.csv'     
  OR list_name like 'Additional plant spp.'       
  OR list_name like 'A short list of kangaroos'  
  OR list_name like 'ALA example'
  OR list_name like 'BAI 2'
)
and 
( list_type='OTHER' OR list_type='SPATIAL_PORTAL' OR list_type='LOCAL_LIST')
and is_authoritative is null;