How to execute a sql query in zend framework 2?

Question

I want to execute a query like the following query in zf2.

SHOW COLUMNS FROM Mytable LIKE 'Mycolumn'

What is the correct way of doing so?

By the way i am using AbstractTableGateway class.

Answer 1

I do it like this:

1. Create an adapter

2. Pass it to the chosen class and run something like this:

   $sql = "SHOW COLUMNS FROM Mytable LIKE 'Mycolumn'"; 
   
   $statement = $this->adapter->query($sql); 
   return $statement->execute(); 
   

Answer 2

I know reply on a very old thread, but maybe some one looking for SELECT with LIKE

 $this->table = $data['table'];
    $select = new Select();
    $spec = function (Where $where) {
        $where->like('company', '%1%');
    };
    $select->from($this->table);
    $select->where($spec);
    $resultSet = $this->selectWith($select);
    $resultSet->buffer();
    return $resultSet;