Searching in a column of any table by a substring

Example : Searching 'Independence day' text in column name leave_desc for 'epen' substring.

SELECT leave_desc FROM tbl_calendar WHERE substring(leave_desc, 4, 4) = 'epen'