SELECT * FROM test WHERE isim LIKE "%i%"
SELECT * FROM test WHERE isim LIKE "%n"
SELECT * FROM test WHERE isim LIKE "Ş%"

SELECT * FROM test WHERE isim LIKE "%Ş%" && soyisim LIKE '%ER%'