How can I select sqlite "check ... in [list]" options in SQLite?

user_14542044 0
Viewed 101

Pretty much everything is in the title. I'm looking for an SQLite equivalent of the following SQL command :

show columns from users where field = "category";

Given that the show statement doesn't exist in SQLite. Thanks in advance

sqlite sql
1 Answers

You can use meta data held in SQLite with query:

select
  sm.name as table_name,
  pti.name as column_name
from
  sqlite_master sm
join
  pragma_table_info(sm.name) as pti
where
  pti.name like '%category%';

It returns (as can be seen) tables with column names. Then, you can filter output by column name, I used for example condition:

where pti.name like '%category%'

which returns only those column names including category.

user_71325500
Related