Posted by Richard Lynch on 03/15/05 18:24

BAD (probably):
>>>> Select blablabla FROM t1,t2,t3
>>>> WHERE customers LIKE '%$s%'
>>>> OR name LIKE '%$s%'
>>>> OR domain LIKE '%$s%'
>>>> OR email LIKE '%$s%'
>>>> OR log LIKE '%$s%'
>>>> AND t1.id = t2.t1_id
>>>> AND t1.id = t3.t1_id

GOOD (usually):
>>>> Select blablabla FROM t1,t2,t3
>>>> WHERE (customers LIKE '%$s%'
>>>> OR name LIKE '%$s%'
>>>> OR domain LIKE '%$s%'
>>>> OR email LIKE '%$s%'
>>>> OR log LIKE '%$s%')
>>>> AND t1.id = t2.t1_id
>>>> AND t1.id = t3.t1_id

Note parentheses added around OR expressions.

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]