Search for a specific word using Liql query

Hi ,   I need to search whether the subject contains a specific word using Liql query . Eg : I am trying to get the messages using select * from messages . I am getting the response with a list of...