By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE laws (title varchar(50))
INSERT INTO laws VALUEs ('Only for male partitipents'),('male and female partitipents'),('No more female partitipents in this law')
SELECT * FROM `laws` WHERE title LIKE '%male%' AND title NOT LIKE '%female%'
| title |
|---|
| Only for male partitipents |