how to convert mysql query to zend query?

Question

I want to convert following sql query to zend query. How I can convert this mysql query into zend query with zend framework 2?

select * from user where BINARY username = "testUser";

Thanks

Possbile answer you were searching stackoverflow.com/questions/10153740/… — knkarthick24
– knkarthick24, Commented Oct 10, 2014 at 9:52

Аймен Ахмед · Accepted Answer · 2014-10-14 15:40:59Z

1

Did you tried this:

$select = $select->where('username' => new \Zend\Db\Sql\Expression("BINARY('testUser')"));

answered Oct 14, 2014 at 15:40

5651 gold badge7 silver badges21 bronze badges

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

1 Comment

Thanks.Thanks a lot.Working successfully. :)

Danis · Accepted Answer · 2014-10-10 09:54:00Z

0

Here how you can write your query in Zend:

$select = $db->select()
             ->from('user')
             ->where('BINARY username = ?', "testUser");

answered Oct 10, 2014 at 9:54

Danis

2,1303 gold badges17 silver badges29 bronze badges

Thanks. But this code it not working in zend framework 2 :( . This is ok with Zend framework 1.