I am using MySQL 5.0.88. I have a query like:
select DISTINCT party.id FROM party LEFT join party_identifier AS pi ON pi.party_id = party.id WHERE (pi.source_note=? AND (first_name LIKE ? OR last_name LIKE ? OR pi.identifier LIKE ?)) AND party.type = ? AND party.record_status_id = ?
Pi.source_note = ? evaluates to false, will the rest of the conditions will evaluated or not?
What is the execution sequence for the where conditions? (In terms specifically of SQL, not programming languages.)