Bug 15343 [QA Followup]
[koha.git] / installer / data / mysql / atomicupdate / bug_15343-add_password_to_PatronSelfRegistrationBorrowrUnwantedField_by_default.sql
1 UPDATE systempreferences SET value = CONCAT_WS('|', IF(value='', NULL, value), "password") WHERE variable="PatronSelfRegistrationBorrowerUnwantedField" AND value NOT LIKE "%password%";