SELECT count(*) FROM university WHERE LOCATION LIKE "%NY%"
Find how many school locations have the word 'NY'.
SELECT count ( * ) FROM university WHERE LOCATION LIKE `` % NY % ''
select count ( * ) from university where location like value
Find how many school locations have the word 'NY ' .