How can I use a custom query to find empty values?

Options
Xano Support Chat
Xano Support Chat Administrator

ADMIN

edited February 2023 in ❓Other questions

Our database has some empty records. How can I retrieve them with a custom query?

Best Answer

  • Xano Support Chat
    Xano Support Chat Administrator

    ADMIN

    edited February 2023 Answer ✓
    Options

    You can leave it completely empty to compare to, so for example I want to find the empty fields where user.name == empty: