Check users in our community

v-vemami,

you can get the users details by using any of the below API's

SELECT id FROM users WHERE login = 'admin'

SELECT email, id FROM users WHERE login = 'admin'

SELECT id FROM users WHERE login IN ('admin', 'SuzieH')

SELECT login FROM users ORDER BY login DESC

SELECT login FROM users WHERE login MATCHES 'john'

SELECT login FROM users WHERE login LIKE '%jane%'

Hi v-vemami , 

If the reply has answered your question, do you mind marking it as an accepted solution? 

Thanks!