[RSS Feed/News] Operator RLIKE missing, any recommendation

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
So when i run query via finder method
PHP:

$user->whereOr(['user_group_id','=',$groupid],['secondary_group_ids','LIKE',$groupid])->limitByPage($page,$perPage)->fetch()->toArray();
It will output 1 users that are in that secondary group, i noticed that when that secondary group id i'm searching is in first place it can be retrieved, otherwise no. But when i run query
Note LIKE operator only returns 1 result from the table.

PHP:

SELECT * FROM `xf_user` WHERE `user_group_id` = 4 OR...

Read more

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom