More flexible constraints

[blm017]

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?

[rpetribu]

Hi!

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

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

[blm017]

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?

[rpetribu]

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

[blm017]

Thanks - perfect