phpmyadmin Question posted in
The official documentation can be found here.

I have that error #1064 in phpmyadmin say Unrecognized statement type. (near "where" at position 46)

SELECT * FROM time_on_screen where id=’2′ AND where date between ‘2020-10-04’ and ‘2020-10-10’

Tags:

2

Answers


  1. 0

    Only one WHERE per select is allowed use and,or and bracketing for multiple conditions/filters

    SELECT * FROM time_on_screen where id='2' AND (date between '2020-10-04' and '2020-10-10')
    Login or Signup to reply.
  2. 0

    Syntax for select clause is

    select – column filter
    from – base table/base tables
    where – initial row fillter

    here only one where clause is allowed in a single select.

    select * from time_on_screen where id = '2' and date between '2020-10-04' and '2020-10-10'
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search