SELECT rID FROM Reviewer WHERE name LIKE "%Mike%"
What is the id of the reviewer whose name has substring “Mike”?
SELECT rID FROM Reviewer WHERE name LIKE `` % Mike % ''
select rid from reviewer where name like value
What is the id of the reviewer whose name has substring “Mike” ?