|
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 |
- |
|
|