0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- select users coming from India, China and US
-- the user table has all the information we need

SELECT *
  FROM Users
  WHERE lower(Location) LIKE '%india%' 
  OR lower(Location) LIKE '%china%'
  OR lower(Location) LIKE '%usa%';

view current version

edited mar 27

created mar 27 anonymous