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

 

Here book- table name

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