MySQL Queries using Doctrine & CodeIgniter

[eluser]01010011[/eluser]
Hi,

How do I write plane SQL queries using Doctrine connection object and display the results? For example, how do I perform:

Code:

SELECT * FROM table_name WHERE column_name LIKE '%anything_similar_to_this%';

using Doctrine something like this (this example does not work)

Code:

$search_key = array('search_for_this');
        
     $conn = Doctrine_Manager::connection();
      
     $conn->execute('SELECT * FROM table_name WHERE column_name LIKE ?',  $search_key);
        
     echo $conn;