William Guilherme
05/20/2020, 8:30 PMSELECT common_name FROM certificates WHERE common_name = 'SGIO Test Root CA - G2' OR 'SGIO Root CA G2' OR 'SGIO ROOT CA' OR 'SGIO Basic Assurance CA2' OR 'SGIO Basic Assurance CA2 G2' OR 'SGIO Basic Assurance CA G2';
zwass
05/20/2020, 8:32 PMWHERE common_name IN (...)
fritz
05/20/2020, 8:40 PMseph
05/20/2020, 8:40 PMIN
seems cleaner. But OR
is the full predicate. So name = foo OR name = bar or name = qux
William Guilherme
05/20/2020, 9:02 PMSELECT common_name FROM certificates WHERE common_name IN (common_name = 'SGIO Test Root CA - G2' OR common_name = 'SGIO Root CA G2' OR name = 'SGIO Root CA' OR common_name = 'SGIO Basic Assurance CA2' OR common_name = 'SGIO Basic Assurance CA2 G2' OR common_name = 'SGIO Basic Assurance CA G2');
seph
05/20/2020, 9:38 PMWHERE common_name IN ('SGIO Test Root CA - G2', 'SGIO Root CA G2')
(consult general sql docs)