Consider the following SQL query to retrieve ecode of employees from STUDENT table, whose address contains 'MUMBAI':
SELECT ecode
FROM STUDENT
WHERE _________;
Which of the following is most suitable to complete the query?
1
address LIKE '_MUMBAI_'
2
address = %MUMBAI%
3
address AS '%MUMBAI_'
4
address LIKE '%MUMBAI%'
5
Question Not Attempted