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 users coming from India,China and USA --
-- after checking the logical model, the user table has all information we need--
select *
from Users
where Location like '%China' 
  OR 
  Location like '%India%' 
  OR 
  Location like 'USA'

fork query

created mar 27 anonymous