# How to look up a user based on a user\_id?

**URL:** https://meta.discourse.org/t/how-to-look-up-a-user-based-on-a-user-id/43739
**Category:** Support
**Created:** [May 5, 2016, 3:09pm UTC](https://meta.discourse.org/t/how-to-look-up-a-user-based-on-a-user-id/43739 "2016-05-05T15:09:04Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![fefrei](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/fefrei/32/119538_2.png) [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [May 6, 2016, 8:14am UTC](https://meta.discourse.org/t/how-to-look-up-a-user-based-on-a-user-id/43739/3 "2016-05-06T08:14:20Z")

</div>

Alternatively, you can use the awesome [Data Explorer plugin](https://meta.discourse.org/t/data-explorer-plugin/32566):

```sql
SELECT *
FROM users
WHERE id = 398

```

---

_[View the full topic](https://meta.discourse.org/t/how-to-look-up-a-user-based-on-a-user-id/43739)._