SELECT *
FROM People
WHERE Name like '%Franklin%' and Name like '%Linsey%'

##</code><code>##

SELECT *
FROM People
WHERE Name LIKE '%Franklin%Linsey%' OR Name LIKE '%Linsey%Franklin%'

##</code><code>##

SELECT *
FROM People
WHERE INSTR(Name,'Franklin')>0 AND INSTR(Name,'Linsey')>0