CREATE TABLE table_45899 ("Name" CLOB, "Listed" CLOB, "Location" CLOB, "County" CLOB, "Type" CLOB)

What bridge is in Mcville?
SELECT "Name" FROM table_45899 WHERE "Location" = 'mcville'
SELECT "Name" FROM "table_45899" WHERE "Location" = 'mcville'