my custom where clause won’t work.
What i like to do is:
We receive Email by a “catch all” to one Mailbox.
Now i like to Forward Emails the Original Email to a staff in House which is no Helpspot User (Helpdesk Staff Agent)
I tried out these clause:
xRequest IN (SELECT xRequestHistory FROM HS_Request_History LIKE CONVERT( _utf8 '%X-Original-to: email@example.com%'
USING latin1 ) COLLATE latin1_swedish_ci)
in PhPMyAdmin it works. I’ve read that i (maybe) have to escape some Characters. But, it doesn’t work.
What is wrong?
Thanks for Help.