syntax help please

[baffled_in_UK]

Hi,

This should be quite straightforward for somebody out there.
I want to select from a MySQL table using this process (note: it's not true code but it shows the process I'm trying to achieve)

SELECT * FROM table WHERE

flda = 'Y' AND fldb LIKE '%$search%'
OR
flda = 'Y' AND fldc LIKE '%$search%'
OR
flda = 'Y' AND fldd LIKE '%$search%'
OR
flda = 'Y' AND flde LIKE '%$search%'

My problem lies in getting the syntax for this process correct.
Can anyone help please.

Thanks

[ednark]

mysql commands are paren groupable like standard math equasions...

if you have an order of opperation problem you can force the way you want with parens

is this what you are looking for?

( flda = 'Y' AND fldb LIKE '%$search%' )
OR
( flda = 'Y' AND fldc LIKE '%$search%' )
OR
( flda = 'Y' AND fldd LIKE '%$search%' )
OR
( flda = 'Y' AND flde LIKE '%$search%' )

[baffled_in_UK]

simple as that huh?

Thanks for replying.