Forum Academy Marketplace Showcase Pricing Features

More flexible constraints

Hi all,
Is there a way to use the database contains in a more flexible way (just like SQL) ?
For example, I want to perform a query for users where their first_name equals their last_name.
How can I do that using the current Bubble’s DB functionality?

Hi!

  1. Do a Search For Users. Don’t use any constraint

  2. After the Search for: insert a : filtered and do as below:

image

Thanks for the answer.
I just want to delete all the users which answer this condition - I don’t want the visual - only the data.
Is there a way to delete all users which their first name equals their last name?

You can perform a “Delete a list of things” action. :wink:

Thanks - perfect :pray: