How to use like query with joins in mysql

I have following tables tax_first

id      file_id     column_id       text
1       10          1               night
2       10          1               night

tax_second

id      file_id     text
1       10          night
2       10          night of the day
3       10          night of the day    

I want to fetch all data where "text"(night) contain any of the word(night of the day),But right now only displaying,data related with "night" not "night of the day",Here is my current query

SELECT ts.*,tf.* 
FROM tax_second ts 
JOIN `tax_first` `tf` 
ON `ts`.`text` = `tf`.`text` 
WHERE ts.text Like '%night%'