---
title: "SQLiteException: no such column"  
description: "SQLiteException: no such column"  
author: "Allen Scott"  
published: 2014-11-17  
updated: 2014-11-17  
canonical: https://www.mindstick.com/forum/12603/sqliteexception-no-such-column  
category: "android"  
tags: ["excel", "sqlite"]  
reading_time: 1 minute  

---

# SQLiteException: no such column

I have the below [method](https://www.mindstick.com/forum/166/webservice-method) that when executed gives the [error](https://yourviews.mindstick.com/view/88527/fixing-quickbooks-error-4120-reinstalling-vs-repairing):

11-09 12:11:17.578: E/AndroidRuntime(21018): Caused by: android.database.sqlite.SQLiteException: no such [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server): happy ([code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) 1): , while compiling: [select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) * from Bank where english = happy

**The method is:**

```
public boolean BankHas(Word currentWord) {        openDataBase();        Cursor cursor = myDataBase.rawQuery("select * from Bank where english = " + currentWord.english, null);         return cursor.moveToFirst();    }
```

**My [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) scheme:**

```
CREATE TABLE `Bank` (    `english`   TEXT);
```

## Replies

### Reply by Mark M

you missed single quote,so change

```
"select * from Bank where english = " + currentWord.englishto"select * from Bank where english ='" + currentWord.english + "'"
```

Or **recommended solution** is to use **parameterized query** as

Cursor cursor = myDataBase.rawQuery("select * from Bank where english =? ", new String [] {currentWord.english});

And change your create table from

```
CREATE TABLE `Bank` (    `english`   TEXT);
```

to

```
CREATE TABLE Bank (    english TEXT);
```


---

Original Source: https://www.mindstick.com/forum/12603/sqliteexception-no-such-column

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.