Yes, LIKE would find that - but only if you specified '%child%'. '%' matches any number of characters, so '%child%' will match any string of characters that contains 'child' somewhere, e.g. 'My eldest child is called Peter', 'I have seven grandchildren', 'Children are funny', 'I am a child' , 'child', or 'xxxxxxxxxxxxxxchildxxxxxxxxxxxxx'.
On it's own 'child' would only match the string 'child'.