pdo fetch column names from table that fit a pattern using only query

Question

Is it possible to fetch all column names that have a pattern? For example, fetch all columns that start with 'allow'. I would like it to only use pure pdo query and not an php array filter.

  $prepare=$database->query("show columns from TABLENAME like 'allow%'");
  $fetched=$prepare->fetchAll();

I wrestled a bear once. · Accepted Answer · 2016-01-18 01:09:20Z

1

Some shared hosts don't let you use the info schema, in those situations you can use show columns, which looks like this.

SHOW COLUMNS FROM `database`.`table` WHERE Field like '%access'

answered Jan 18, 2016 at 1:09

I wrestled a bear once.

23.5k20 gold badges74 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maciek · Accepted Answer · 2016-01-18 01:01:46Z

0

information_schema.columns holds column and table structure information.

$prepare=$database->query("select column_name from information_schema.columns where table_name='TABLENAME' and column_name like 'allow%'");
$fetched=$prepare->fetchAll(PDO::FETCH_COLUMN);
print_r($fetched);

answered Jan 18, 2016 at 1:01

Maciek

2,01026 silver badges45 bronze badges

Collectives™ on Stack Overflow

pdo fetch column names from table that fit a pattern using only query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related