MD5 of column value in where clause
mridah opened this issue · 1 comments
mridah commented
kwhat commented
$value = 'value-to-compare-to';
$database->select()
->from('mytable')
->where(new Conditional('md5("some-salt" + id)', '=', $value))
->execute();
OR
$database->select()
->from('mytable')
->where(new Conditional('md5("some-salt" + id)', '=', new Raw('value-to-compare-to')))
->execute();