Hi @asmecher,
My problem is a little different.
SELECT DISTINCT s1.setting_name FROM journal_settings s1, journal_settings s2 WHERE s1.setting_name = s2.setting_name AND s1.locale = ‘’ AND s2.locale <> ‘’;
Return another setting_name besides metaCitations:
±--------------------+
| setting_name |
±--------------------+
| metaCitations |
| pageHeaderLogoImage |
±--------------------+
Aboute metaCitations,
select setting_name, setting_type, locale from journal_settings where setting_name like ‘metaCitations’;
shows me that…
±--------------±-------------±-------+
| setting_name | setting_type | locale |
±--------------±-------------±-------+
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | es_ES |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | en_US |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | es_ES |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | en_US |
| metaCitations | string | es_ES |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | es_ES |
| metaCitations | string | en_US |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | string | pt_BR |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
| metaCitations | bool | |
±--------------±-------------±-------+
I have to delete every column where setting_name like ‘metaCitations’ and setting_type = ‘string’.
But what about pageHeaderLogoImage?
select setting_name, setting_type, locale from journal_settings where setting_name like ‘pageHeaderLogoImage’;
which setting_type I have to delete?
±--------------------±-------------±-------+
| setting_name | setting_type | locale |
±--------------------±-------------±-------+
| pageHeaderLogoImage | object | |
| pageHeaderLogoImage | int | heigh |
| pageHeaderLogoImage | string | dateU |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | |
| pageHeaderLogoImage | string | name |
| pageHeaderLogoImage | string | uploa |
| pageHeaderLogoImage | object | |
| pageHeaderLogoImage | int | width |
| pageHeaderLogoImage | string | name |
| pageHeaderLogoImage | string | uploa |
| pageHeaderLogoImage | int | width |
| pageHeaderLogoImage | object | |
| pageHeaderLogoImage | object | |
| pageHeaderLogoImage | int | heigh |
| pageHeaderLogoImage | string | dateU |
| pageHeaderLogoImage | string | name |
| pageHeaderLogoImage | string | uploa |
| pageHeaderLogoImage | int | width |
| pageHeaderLogoImage | int | heigh |
| pageHeaderLogoImage | string | dateU |
| pageHeaderLogoImage | string | name |
| pageHeaderLogoImage | string | uploa |
| pageHeaderLogoImage | int | width |
| pageHeaderLogoImage | int | heigh |
| pageHeaderLogoImage | string | dateU |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | pt_BR |
| pageHeaderLogoImage | object | pt_BR |
±--------------------±-------------±-------+