[TYPO3-mvc] complex queries

[Cornelius Illi]

Hello again,

what I need to do is something like this:

|SELECT  *  FROM  tx_ext_domain_model_m  WHERE  CONCAT_WS("",  f1,f2,f3,f4)  LIKE  '%myString%'

what I have so far is something like this:
$query = $this->createQuery();
$query->matching( $query->like('f1' , '%'.$piVars["name"].'%' ) );

I tried a lot, but I am not making any progress. Any ideas.
Thanks to all for the earlier advise and responses.
Cheers, Cornelius
|