这可以通过REGEXP来实现，如下所示：

SELECT * FROM `keywords` WHERE keyword REGEXP '([^p]|^)p([^p]|$)' AND keyword LIKE '%pp%';

测试和解释：（MySQL Workbench 8.0 CE）

drop table if exists keywords;
create table keywords(
keyword varchar(50)
);
insert into keywords values("hippo");
insert into keywords values("hippopotamus");
insert into keywords values("zpp");
insert into keywords values("zp");
insert into keywords values("zpzpp");
insert into keywords values("zppzp");
insert into keywords values("zppzpzzzzzppzppzp");
insert into keywords values("p");
insert into keywords values("pp");
SELECT * FROM `keywords` WHERE keyword REGEXP '([^p]|^)p([^p]|$)'; -- Returns words with 'p' that isn't 'pp'
SELECT * FROM `keywords` WHERE keyword LIKE '%pp%'; -- Returns words with 'pp'
SELECT * FROM `keywords` WHERE keyword REGEXP '([^p]|^)p([^p]|$)' AND keyword LIKE '%pp%'; -- Combine to get desired effect
-- Should only get 'hippopotamus' 'zpzpp' 'zppzp' and 'zppzpzzzzzppzppzp'

我建议在这里使用MySQL REGEXP，smth像这样：

WHERE keyword REGEXP '(?=^.*?[^p](p)[^p].*?$)(?=^.*?[^p](p{2})[^p].*?$)'

我还没有测试过，但只有当p和pp以任何顺序同时出现时，它才应该为真