SELECT count(*) FROM files WHERE duration LIKE "4:%"
How many songs have 4 minute duration?
SELECT count ( * ) FROM files WHERE duration LIKE `` 4 : % ''
select count ( * ) from files where duration like value
How many songs have 4 minute duration ?