SELECT pii2 FROM 'surveys_egresados' WHERE pii2 = 'Very good' BETWEEN date = '2017-01-01' AND '2017-01-01'; [closed]

Question

Navigation

#1 by (2 votes)
#2 by (0 votes)

0

I have a syntax error in the following statement

SELECT pii2 
FROM 'encuestas_egresados'
WHERE pii2='Muy buena'
BETWEEN fecha ='2017-01-01' AND '2017-01-01' ;

mysql sql

asked by jDanielSotoC 21.12.2017 в 00:10

source

2 answers

Use own server with phonegap Hide and show content when pressing buttons?

score 2 · Answer 1

The following condition is not correct:

BETWEEN fecha ='2017-01-01' AND '2017-01-01'

It should be:

AND fecha BETWEEN '2017-01-01' AND '2017-01-01'

.. although, in this particular case, since both dates are the same, you do not even need to use BETWEEN :

AND fecha = '2017-01-01'

score 0 · Answer 2

0

It would be:

SELECT pii2 
FROM 'encuestas_egresados'
WHERE pii2='Muy buena'
AND fecha BETWEEN '2017-01-01' AND '2017-01-01' ;

answered by 21.12.2017 в 00:54