MYSQL Ignores AND clause in my query

Question

I have the following query, the AND state = 1 is being ignored, i get all the states instead of only what is equal to 1. Where is my mistake here?

$query = "
                SELECT state, id, variable, name, {$columns->specific}, {$columns->allExcept}, {$columns->specificExclude}, {$columns->relationAllExcept}, repeatable

                FROM #__epc_fieldsgroups
                WHERE FIND_IN_SET({$relationRecordId}, {$columns->specific})

                OR {$columns->allExcept} != 0
                AND FIND_IN_SET({$relationRecordId}, {$columns->allExcept}) = 0

                AND state = 1
                ORDER BY ordering
             ";

What duplicated about that? its a completely different query with a completely different syntax. The solution posted there is not valid for my problem. — Danigoodw, Sep 18 '16 at 16:13

score 0 · Answer 1 · answered Sep 18 '16 at 10:19

you need to define start and end of AND using parentheses

$query = "
                SELECT state, id, variable, name, {$columns->specific}, {$columns->allExcept}, {$columns->specificExclude}, {$columns->relationAllExcept}, repeatable

                FROM #__epc_fieldsgroups
                WHERE FIND_IN_SET({$relationRecordId}, {$columns->specific})

                OR {$columns->allExcept} != 0
                AND {FIND_IN_SET({$relationRecordId}, {$columns->allExcept}) = 0}

                AND {state = 1}
                ORDER BY ordering
             ";

Doing so ending up with a syntax error. Am i missing something? — Danigoodw, Sep 18 '16 at 16:14

MYSQL Ignores AND clause in my query

1 Answers1