is there mysql operator `both`

Question

I am using CodeIgniter with GroceryCrud, when I am tring to do a search the response is mysql error.

the error contains the next message:
Error Number: 1064</p><p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'both last_action_date LIKE '%11%' both package_id LIKE '%11%' both at line 6

and here is part of the relevant query

...FROM (`users`)
LEFT JOIN `users` as j9e598a93 ON `j9e598a93`.`id` = `users`.`accountant_id`
LEFT JOIN `users` as j0b70ca4c ON `j0b70ca4c`.`id` = `users`.`affiliate_id`
WHERE  `id`  LIKE '%11%'
both `last_action_date`  LIKE '%11%'
both `package_id`  LIKE '%11%'

I am not familiar with the "BOTH" mysql operator and I could not find it.

does anyone knows this operator? is it really exists or it's a GroceryCrud bug?

Answer 1

does anyone knows this operator?

In your query the BOTH token assumed to be used as an infix boolean operator. There is no such defined in mysql, hence mysql query parser fails to parse a query.

is it really exists or it's a GroceryCrud bug?

It definitely is a bug caused by generating incorrect SQL query.