>From your original SQL, it looks like you want to AND two LIKE
statements (which is guaranteed to be very slow), but that said, why
not just do that in your conditions:
$whereArray = array('conditions' => array(
'AND' => array(
'referer like %google%',
'referer like %\%E6\%B5\%81\%E7\%A8\%8B
\%E5\%9B\%BE%',
'request_path like /blog/posts/view/
flowchart-howtos%'
)
)
On Dec 22, 12:01 am, "[email protected]" <[email protected]>
wrote:
> Hi all, I have such a SQL statement to query:
> SELECT * FROM `mytable` WHERE `referer` LIKE '%google%' AND `referer`
> LIKE '%\%E6\%B5\%81\%E7\%A8\%8B\%E5\%9B\%BE%' AND `request_path` LIKE
> '/blog/posts/view/flowchart-howtos%'
>
> I use the column `referer` twice in the same SQL query.
>
> I tried with
>
> $this->LogParser->find(array('referer LIKE'=>array('%google%', '%\%E6\
> %B5\%81\%E7\%A8\%8B\%E5\%9B\%BE%'), 'request_path LIKE'=>'/blog/posts/
> view/flowchart-howtos%'));
>
> which gave me
>
> ... WHERE `referer LIKE` IN ('%google%', '%E6%B5%81%E7%A8%8B%E5%9B
> %BE') ...
>
> apparently that is not correct.
>
> Any can kindly help me? Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
