How can I use some MySQL builtin function in PHQL

Question

How can I use some MySQL builtin function in PHQL

Mojtaba Ebrahimi Oct '15

Created Oct '15	Last Reply Oct '15	Replies 1	Views 685	Votes 0

Mojtaba Ebrahimi 3.1k

Oct '15

Hi there, I want check some string in DB in lower case.

For example I want to run this query in MySQL DB using PHQL :

SELECT *
FROM  Users
WHERE  LOWER(username)  = 'john'

I don't want to use raw query.

How can I do that?

Thanks

Patrick Ascher · Answer 1 · 2015-10-12T06:49:39-07:00

You can use normal SQL Statements. But then you kind of bind your project to mySQL. If thats no problem for you, you can use something like that:

//$anyModel is just a Model() object.
$result = new \Phalcon\Mvc\Model\Resultset\Simple(null, $anyModel, $anyModel->getReadConnection()->query('DESCRIBE _auth_users;'));

Mojtaba Ebrahimi · Answer 2 · 2015-10-13T02:28:15-07:00

Your solution can't help me. I don't want to dependent my project to a specific databse.

I was think that ORM handle this problem.

Thanks for your reply.

You can use normal SQL Statements. But then you kind of bind your project to mySQL. If thats no problem for you, you can use something like that:
//$anyModel is just a Model() object.
$result = new \Phalcon\Mvc\Model\Resultset\Simple(null, $anyModel, $anyModel->getReadConnection()->query('DESCRIBE _auth_users;'));