please could you make for me a good Query that can work with my IDE
=======
https://stackoverflow.com/questions/68879924/how-to-select-some-fields-have-same-prefix-names
======
i have this Table: [USERS] has 07 Fields:
- ID (PRIMARY kEY)
- USER.NickName
- USER.Password
- EMAIL.Recovery
- REG.Insert_DateTime
- REG.Edit_DateTime
- PICTURE
I need to Select just TWO Fields using Query like that:
SELECT "SELECT " || GROUP_CONCAT(name) || " from USERS" "FROM PRAGMA TABLE_INFO('USERS')"
WHERE SUBSTR(NAME,1,5)="USER."
what i mean Above is to load into my Query just this TWO Fields:
- USER.NickName
- USER.Password