Your question isn't particularly clear. Any SELECT statement will result in a transitional lock - anything else would break ACID. This is not a "problem", but an essential feature of any DBMS.
The wildcard (*) is very far from a "fast-track to not put the columns name". If anything, it's the opposite of a fast-track.
Without knowing what exactly you're doing or why, it sounds to me like you're opting for oversimplifying your queries for personal convenience, and then complaining about the performance implications of doing that. If that is correct, I'd recommend you take a step back and either learn more about how a DBMS works, or ask a more experienced colleague for help.