You can also use the logical operators AND, OR, and NOT in your MySQL WHERE queries to further narrow down your selections. Next example shows one instance of each, but you can mix and match them in any way you need.
Using logical operators:

SELECT author,title FROM classics WHERE
author LIKE “Aro%” AND author LIKE “%Markku”;
SELECT author,title FROM classics WHERE
author LIKE “%Matti ja Teppo%” OR author LIKE “%Esa Mäkelä%”;
SELECT author,title FROM classics WHERE
author LIKE “Aro%” AND author NOT LIKE “%Markku”;