MySQLi query not working. Multiple AND statements

Question

Im trying to add an extra AND statement to my SQL query. I work fine as:

SELECT * FROM tsv WHERE YEAR(`Reporting Date`) = 2017 AND MONTH(`Reporting Date`) = 6

But when I try to add the extra line (AND ISRC = QZERG1727327) in the end it dosen´t work any more

SELECT * FROM tsv WHERE YEAR(`Reporting Date`) = 2017 AND MONTH(`Reporting Date`) = 6 AND ISRC = QZERG1727327

It´s hard to find any solutions online, I really don´t know what to do.

you should show us the error message, and by the way, isn't ISRC string? — zebnat, Sep 30 '18 at 20:28
Is `ISRC` a string? Then `QZERG...` should be in single quotes. — Karsten Koop, Sep 30 '18 at 20:29
You can use the first statment only then with php check if $row["ISRC"]==QZERG1727327 then add the row to array of result — Osama, Sep 30 '18 at 20:31
@Osama Actually I think that would be a way around it! Thanks! But I´m not feeling that it´s the right way to do it and it would probably have to load more than if I could sort it out in the query :) — Jonas Borneland, Sep 30 '18 at 20:35
that's a backtick, single quote would be `'` (btw. the apostrophes in your comments also look wrong) — Karsten Koop, Sep 30 '18 at 20:35
@KarstenKoop OHH yes!! that did the trick :D thanks.. will you post this as an answer? — Jonas Borneland, Sep 30 '18 at 20:36
So only add a quote around ISRC value because it is a string — Osama, Sep 30 '18 at 20:37
Thanks @Osama! but I´ve alrready sorted it out with Karsten :) — Jonas Borneland, Sep 30 '18 at 20:41

Karsten Koop · Accepted Answer · 2018-10-11T21:37:18.887

4

Strings in SQL have to be enclosed in single quotes, so your query should be

SELECT * FROM tsv 
WHERE YEAR(`Reporting Date`)=2017 AND MONTH(`Reporting Date`)=6 
  AND ISRC='QZERG1727327'

edited Oct 11 '18 at 21:37

answered Sep 30 '18 at 20:38

Karsten Koop

1 Answers1