Combining AND & OR in MySQL Queries

[eluser]sideshowbob[/eluser]
Hi Everyone,

I have what I thought was a simple question but I'm struggling to find the answer...

Within CI how do I create a query that produces the following :

Code:

SELECT * FROM Persons WHERE
LastName='Svendson'
AND (FirstName='Tove' OR FirstName='Ola')

There can be many LastNames and Firstnames.

I can create the query easily without the brackets but then it is not the same query.

Thanks!
Bob