Doctrine: how to create a query using "LIKE REPLACE" ?
- by user248959
Hi,
this SQL clause is working OK:
SELECT * FROM `sf_guard_user` WHERE nombre_apellidos LIKE REPLACE('Mar Sanz',' ','%')
Now I'm trying to write this query for Doctrine. I have tried this:
$query->andWhere(sprintf('%s.%s LIKE REPLACE (?," ","%")',
                         $query->getRootAlias(), $fieldName),
                 'Mar Sanz'));
but I get this error:
Warning: sprintf() [function.sprintf]: Too few arguments
Any idea?
Regards
Javi