Yes, MySQL (indeed all database systems as far as I’m aware) will stop processing when a row is returned when using an Exists function.
You can read more at the MySQL documentation:
If a subquery returns any rows at all, EXISTS subquery is TRUE.
Yes, MySQL (indeed all database systems as far as I’m aware) will stop processing when a row is returned when using an Exists function.
You can read more at the MySQL documentation:
If a subquery returns any rows at all, EXISTS subquery is TRUE.