| Lines 141-147
          will update all patrons with no value for email
      
      
        Link Here | 
        
          | 141 | --where 'categorycode LIKE "%CHILD"' | 141 | --where 'categorycode LIKE "%CHILD"' | 
        
          | 142 | will update all patrons with a category ending in CHILD. | 142 | will update all patrons with a category ending in CHILD. | 
        
          | 143 |  | 143 |  | 
          
            
              | 144 | --where 'categorycode LIKE RESIDENT%' | 144 | --where 'categorycode NOT LIKE RESIDENT%' | 
        
          | 145 | will update all patrons whose category does not begin with RESIDENT. | 145 | will update all patrons whose category does not begin with RESIDENT. | 
        
          | 146 |  | 146 |  | 
        
          | 147 | =back | 147 | =back | 
            
              | 148 | -  |  |  |