CREATE TABLE table_49786 ("Name" CLOB, "Location" CLOB, "Country" CLOB, "Longest span" CLOB, "Comp" FLOAT, "Pylons" CLOB)

Where is the kap shui mun bridge?
SELECT "Location" FROM table_49786 WHERE "Name" = 'kap shui mun bridge'
SELECT "Location" FROM "table_49786" WHERE "Name" = 'kap shui mun bridge'