Syntax error while passing Sql Query to Android [duplicate]

Question

I am trying to execute query like

Select  * From Table_name where English=' + word + "'"

and error i am getting is

09-23 07:41:21.995: E/AndroidRuntime(4693): android.database.sqlite.SQLiteException: near "AM": syntax error (code 1): , while compiling: Select  * From Table_Name where English='MA'AM'

I have refered the link android.database.sqlite.SQLiteException: near "...": syntax error (code 1) but that also gives me error like

09-23 08:27:08.710: E/AndroidRuntime(5581): android.database.sqlite.SQLiteException: near "MA": syntax error (code 1): , while compiling: Select  * From Tabel_Name where English=?MA'AM

So my question is how can i pass this query with MA'AM this kind of words.

PS: Other words which does not have ' is working fine so there is no issue with any other code, just query only which is creating problem.

Thanks in advance.

@Jens, I am android developer so i dont have much knowledge of SQL, but still if you can provide any URL or example that would be better to understand the scenario... — user3686177
– user3686177, Commented Sep 23, 2016 at 12:12
@laalto, i am getting error if i use the query like in that question... So please do not mark this question as duplicate.. That this is different scenario... — user3686177
– user3686177, Commented Sep 23, 2016 at 12:29
It's the same: ' in a SQL string literal is a problem and the best solution is to use ? variables and bind the values. — laalto
– laalto, Commented Sep 23, 2016 at 12:31

Bharat · Accepted Answer · 2016-09-23 12:16:25Z

0

You must have to write like this

English='MA''AM'

edited Sep 23, 2016 at 12:16

answered Sep 23, 2016 at 12:04

Bharat

2,4643 gold badges28 silver badges37 bronze badges

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

6 Comments

user3686177 Over a year ago

So what if words have only String like MAM, i mean word which does not have any ', whether this query work with that words too..

Bharat Over a year ago

dynamically you have to replace it 'MA''AM'

user3686177 Over a year ago

Can you tell me how can i fire query to get all words which contains ', this would be big help from your side.

Bharat Over a year ago

SELECT * FROM TableName WHERE FieldName LIKE '%''%'

Bharat Over a year ago

this will get you all records which contains '

|

Collectives™ on Stack Overflow

Syntax error while passing Sql Query to Android [duplicate]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related