如何在带有doctrine 1.2的where子句中应用函数

Question

Imagine i want to search a phone number in my DB but they are saved with different formats

Exemple : 12345678 13.36.15.36 13.654.365

What is the best way with doctrine to find a given phone.

I wish i could do something like this

Doctrine_Core::getTable('user')->create('u')->where(str_replace('.', '', u.phone) = ?, $phone)

Is there some kind of way to achieve this ?

Answer 1

I have tried using sql functions in the select method like concat and date_format. I don't see why replace wouldn't work.

Try this:

$q = Doctrine_Query::create()
     ->select("REPLACE(telnumber,'.','') as tel")
     ->from("user")
     ->where('tel = ?',123456);

To get your results in array format:

$q->execute(array(),Doctrine_Core::HYDRATE_ARRAY);