我已经添加了一个域。 我想用certbot为新域启用https。 遵循此https://certbot.eff.org/lets-encrypt/ubuntubionic-apache sudo certbot --apache
[sudo] password for qq:
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator apache, Installer apache
Which names would you like to activate HTTPS
我有以下查询来选择由两个点分隔的三个级别的域名:
select domainname from db.table
where criteria like ('*.com')
AND domainname like ('%.%.%');
现在,我需要按域名的.%.%部分而不是%.%对结果进行排序。如何将此添加到我的查询中?