select * from book where bookname like '%i%'

Here book- table name

bookname:- name of book on which u want to filter