0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

select Id,
'id range' = case 
  when Location like '%China' then 'from China'
  when Location like '%India' then 'from India'
  else 'from the rest of the world'
end
from Users

fork query

edited mar 20

created mar 20 anonymous