php - Select multiple equals from same table mysql -

creating database search system searches input value fixed element dropdown using php , mysql

e.g.

select * mytable fname '%input%' or lname '%input%' , city = 'dublin'; 

the problem last part being executed, results display dublin , ignores first part.

how structure query properly?

a or b , c may not evaluate want:

select 1 or 0 , 0; -- 1 

instead: (a or b) , c where:

select (1 or 0) , 0; -- 0