Consider the following SQL query to retrieve ecode of employees from EMPLOYEE table, whose address contains 'INDIA':
SELECT ecode
FROM EMPLOYEE
WHERE _________;
Which of the following is most suitable to complete the query?
1
address LIKE '_INDIA_'
2
address = %INDIA%
3
address AS '%INDIA_'
4
address LIKE '%INDIA%'
5
address LIKE 'INDIA'