android.database.sqlite.SQLiteException: near "where": syntax error (code 1):

Question

I am gettingandroid.database.sqlite.SQLiteException: near "where": syntax error (code 1): exception in the below code..Where i am going wrong?

String selectQuery = "SELECT  * FROM " + TABLE_VIDEO + " order by " + KEY_TIMESTAMP + " ASC "+"where " + KEY_TYPE + "='trending'";

Phantômaxx · Accepted Answer · 2015-03-10 20:08:19Z

4

ORDER BY must be the last SQL clause in your query.
So, it must come after the WHERE condition.

edited Mar 10, 2015 at 20:08

answered Mar 10, 2015 at 19:38

Phantômaxx

38.1k21 gold badges88 silver badges122 bronze badges

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

2 Comments

Derek W Over a year ago

Suggestion for improvement: What you are saying here is technically untrue as LIMIT comes after ORDER BY in the SELECT statement.

Phantômaxx Over a year ago

Yep, true. I wasn't considering that. Edited.

Derek W · Accepted Answer · 2015-03-10 19:39:19Z

1

ORDER BY must come after WHERE in the SELECT statement.

See here for more details.

answered Mar 10, 2015 at 19:39

Derek W

10.1k6 gold badges62 silver badges69 bronze badges

Comments

Carlos Carrizales · Accepted Answer · 2015-03-10 19:53:19Z

-1

may be the:

/*code*/+ " ASC "+"where "+ /*morecode*/

try:

 /*code*/+ " ASC WHERE "+ /*morecode*/

answered Mar 10, 2015 at 19:53

Carlos Carrizales

2,3503 gold badges20 silver badges24 bronze badges

4 Comments

Phantômaxx Over a year ago

What does it change? The result would be the same: ASC WHERE. Only the execution speed will be faster (about 0.001 nanosecond?) in the second case, because of one less string concatenation.

Carlos Carrizales Over a year ago

you are right, but i just want to help, nothing more, see ya

Phantômaxx Over a year ago

Well, you did not, sorry.

Phantômaxx Over a year ago

Really, this post provides no answer at all.

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: near "where": syntax error (code 1):

3 Answers 3

2 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related