Do simple thing write a simple query like this you will get actual result.

SELECT nametype1, nametype1, CASE WHEN nametype1= nametype1THEN '1' ELSE '2' END AS nameval

FROM...