Search all certs by word

[Robert]

Hello,

Is it possible to search cert.sh to find all subdomains and domains with a given keyword?

For example:

SELECT distinct x509_commonName(cai.certificate), name_value
FROM certificate_and_identities cai
WHERE lower(cai.NAME_VALUE) LIKE '%example%';

For now I get ERROR:  canceling statement due to conflict with recovery

Query is too heavy? Maybe is the other way? I want use it to find phishing websites

[r...@sectigo.com]

Hi Robert.  Sorry, there aren't currently any indexes to support substring searches.