SQLite Forum

Select by column id
Hi everyone, I'm new to the SQLite, there's one thing I am wondering, after tons of researches on google and youtube, still can't find the answer.

So my question is, can I select by calling the column id like the primary key, the rowid? Or can I select it by calling a variable that stored the name of the column? 

Thank you all, any reply will be appreciated!