Problem in fetching data using LIKE keyword

Hello all
I am trying to fetch data from my MYSQL database, but i am facing problem. My query is
Select title, ref from algorithm where title like '_%test' order by DateTime DESC;

Suppose I want to search a line which contains the word TEST and data in my database is

This is test
He is trying to test the application
TEST of mathematics

Now the problem is that the query only returns that row which has TEST as its last word, i-e this query will return the first row only coz the word TEST is at the end of the line. If i try to search the word TRYING, the query doesn't return any result.. plz help me out.

 

Try: where title like '_%test%'

 

Try: where title like '%test%'

why need a _

 

Thank you both of u
Let me try it

 

Thank you, I tried without _ , and it worked fine for me.