CREATE TABLE table_55746 ("Name" CLOB, "Country" CLOB, "Type" CLOB, "Moving from" CLOB, "Transfer window" CLOB, "Transfer fee" CLOB)

Name the name that has moving of 1. fc n rnberg.
SELECT "Name" FROM table_55746 WHERE "Moving from" = '1. fc nürnberg'
SELECT "Name" FROM "table_55746" WHERE "Moving from" = '1. fc nürnberg'