or_Like Question

[eluser]DanTheMan[/eluser]
The above outputs the following code when $match = new;

Code:

SELECT * FROM (`customer`) WHERE `bb_id` = '28' AND `fname` LIKE '%new%' OR `lname` LIKE '%new%' OR `email` LIKE '%new%' LIMIT 10

The intended output would be that it displays only where the bb_id is equal to 28. However, the real output will display all the records in the database with any bb_id that matches new.

Thanks,
Dan