Where clause results not finding strings with embedded single quotes

General
1

I used both the REST console and Data Browser to query a column where I know the data has an embedded single quote. For example searching for ‘Kevin O’neil’ in the where clause. This is true of columns with the String and TEXT data types.

Search string MO=‘Kevin ONeil’
https://api.backendless.com/v1/data/MS?where=MO%3D’Kevin%20ONeil’

The returned incorrect result is -
{ “nextPage”: null,
“data”: [],
“offset”: 0,
“totalObjects”: 0
}

2

Accordingly to the SQL rules single quotes are escaped by doubling them up, so your query would look like this:

MO = ‘Kevin O’‘Neil’

Cheers,
Mark

3

Thanks,

That works and what I needed.