# Vérification des profils utilisateurs pour détecter les liens inappropriés

**URL:** <https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718>\
**Category:** Product Support\
**Created:** [Avril 6, 2018, 12:42 UTC](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718 "2018-04-06T12:42:19Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![mikechristopher](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mikechristopher/32/89135_2.png) [@mikechristopher](https://meta.discourse.org/u/mikechristopher)\
**Post date:** [Avril 6, 2018, 3:04 UTC](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718/5 "2018-04-06T15:04:22Z")

</div>

The order by seems to work ok for me - may need to add a disclaimer saying they need to put whatever they are looking for in between the %% where you have the term in order to return it (some people may not know SQL).

Otherwise you could just change the line

```plaintext
AND up.website ILIKE :url

```

to

```plaintext
AND up.website IS NOT NULL

```

To return all profiles with a webaddress.

---

_[View the full topic](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718)._