SELECT count(*) FROM train WHERE name LIKE "%Express%"
How many trains have 'Express' in their names?
SELECT count ( * ) FROM train WHERE name LIKE `` % Express % ''
select count ( * ) from train where name like value
How many trains have 'Express ' in their names ?