Using Wildcard Sql for searching a word in a TextField

To make it clearer I have this fields

 Columntobesearch
   aword1 bword1
   aword2 bword2
   aword3 bword4

Now what I want to do is search using the sql wild card so what I did is like this

 %searchbox% 

I placed to wildcards on both ends of my search but what it searches is just the first word on the field

when I search 'aword' all of the fields is showing but when I search 'bword' nothing is showing, Please help.