Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Monday 1:36 am
Add a reply View Replies (2)

Resolved Custom SQL WHERE question

  1. WWA
    WWA
  2. Support
  3. Monday, January 31 2022, 09:32 PM
I am using Custom SQL WHERE to hide some users in a user list menu item. Payment status is a selection field. This command works fine.

user_id NOT IN (210,374) AND payment_status NOT LIKE 'suspended' AND payment_status NOT LIKE 'withdrawn'

but when I add another NOT LIKE it breaks.

user_id NOT IN (210,374) AND payment_status NOT LIKE 'suspended' AND payment_status NOT LIKE 'withdrawn' AND payment_status NOT LIKE ‘member-elect’

Can you help? Thanks.
  1. user list
  2. custom sql
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
maybe the problem is into quote char, in your code I see some char like '...' and other like ‘...’

You can also set a query like this 
user_id NOT IN (210,374) AND payment_status NOT IN ('suspended','withdrawn','member-elect')
it's easier than put many AND
  1. more than a month ago
  2. Support
  3. # 1
WWA
WWA Accepted Answer
Pro
Perfect. Thanks.
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.