my project requires that the user could search for a product by its name
so i have to select all records which contain a specific word(which the user has entered)
i was trying “select Name from Products where Name Like ‘%” + keyword + “%'”
but i didn’t work
any solution ?