mysql - Searching database using keyword that will display all subject from database that has the keyword -

i creating system tracking coming in , out documents in office. user should able view reports or record. have created simple textbox serve search tool. search process should allow user select datagridview using keyword.

example: if user search record has keyword of "book" subject has word "book" in should appear. example: keyword: book

     displays in datagridview: book of secrets                                book shelf                                record book 

regardless of uppercase or lowercase. kinda google

i tried creating search process shows exact word , not statement word "book"

this code

try             connection.open()              dim query string             query = "select id,type_of_document,items,received_from,received_date,remarks,marginal_note,referred_to,referred_date,action_taken  tracker.recordtracker items = '" & srchtbx.text & "'"             command = new mysqlcommand(query, connection)             adapter.selectcommand = command             adapter.fill(dataset)             bind.datasource = dataset             datagridview1.datasource = bind             adapter.update(dataset)             connection.close()         catch ex exception             msgbox(ex.message)                     connection.dispose()         end try 

any appreciated

in put %

where items '%" & srchtbx.text & "%'