SELECT count(*) FROM university WHERE LOCATION LIKE "%NY%"
How many universities have a location that contains NY?
SELECT count ( * ) FROM university WHERE LOCATION LIKE `` % NY % ''
select count ( * ) from university where location like value
How many universities have a location that contains NY ?