Using LIKE and equal in SQL statement

Question

Is there something wrong with this SQL statement? Specifically, in the "LIKE ? AND deck_id = ?" part.

"SELECT * FROM cards WHERE 
  card_one LIKE ? OR card_two LIKE ? OR card_three LIKE ? 
  AND deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ?
  OR deck_id = ? OR deck_id = ? OR deck_id = ?"

It searches for card_one and card_two properly, but not the third. If I take card_three out, then card_two does not work. Which leads me to believe that something in that area isn't right.

Can you use LIKE with AND in this way?

Desired results are

"SELECT * FROM cards WHERE (card1-3 LIKE ?) AND (Deck_id = decks_array)"

if that makes sense.

You probably should add some parenthesis around your clauses. Mixing OR and AND doesn't do what you think. — gen_Eric
– gen_Eric, Commented Nov 7, 2014 at 23:45
Use some parantheses: (card_one LIKE ? OR card_two LIKE ? OR card_three LIKE ?) AND (deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ?") — ROMANIA_engineer
– ROMANIA_engineer, Commented Nov 7, 2014 at 23:45
P.S. Replace deck_id = ? OR deck_id = ? OR deck_id = ? with deck_id IN (?,?,?). — gen_Eric
– gen_Eric, Commented Nov 7, 2014 at 23:46

Andrej · Accepted Answer · 2014-11-07 23:46:47Z

3

"SELECT * FROM cards WHERE 
  (card_one LIKE ? OR card_two LIKE ? OR card_three LIKE ?) 
  AND deck_id in (id1,id2,id3)

answered Nov 7, 2014 at 23:46

Andrej

7,5041 gold badge22 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jacob Lambert · Accepted Answer · 2014-11-07 23:45:00Z

2

You need to add (...) around your conditions like so:

"SELECT * FROM cards WHERE 
 ( card_one LIKE ? OR card_two LIKE ? OR card_three LIKE ? )
 AND ( deck_id = ? OR deck_id = ? OR deck_id = ? OR deck_id = ?
       OR deck_id = ? OR deck_id = ? OR deck_id = ? )"

answered Nov 7, 2014 at 23:45

Jacob Lambert

7,7278 gold badges31 silver badges51 bronze badges

Collectives™ on Stack Overflow

Using LIKE and equal in SQL statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related