XF 2.1 Compare 2 column in finder->where()

[abdfahim]

Can a finder object comapres values of 2 columns? I tried the following, but the result was inconsistent
$finder->where('col_1', '=', 'col_2')

Basically, I am trying to replicate the following SQL query

WHERE col_1 = col_2

 

[nocte]

try $finder->columnSqlName('col_2')

 

[abdfahim]

try $finder->columnSqlName('col_2')

This translates into WHERE `table_name`.`col_1` = '`table_name`.`col_1`'.

So, not working as expected.

 

[nocte]

right.. try:

$finder->whereSql(
    '%s = %s',
    $finder->columnSqlName('col_1'),
    $finder->columnSqlName('col_2')
);