How to query data

[pkasson]

I can query a table which has a numeric column ok, but when I query a table with a column that is string, it fails with a sql error:

This query works, on a numeric column:

select _name, age, sex from animals where age > 3

it returns the proper results .. but this fails:

select _name, age, sex from animals where sex = “M”

it returns the following error:

"Binder Error: Referenced column "“M”" not found in FROM clause!\nCandidate bindings: "animals.age"\nLINE 1: ...ame, age, sex from animals where sex = “M”\n

[stensoosaar]

try 'M' not "M"

[pkasson]

I tried that as well ...

select _name, age, sex from animals where sex = ‘M’

Referenced column "‘M’" not found in FROM clause!\nCandidate bindings: "animals.age"\nLINE 2: from animals where sex = ‘M’\n

[stensoosaar]

You should check your string formatting.

let query = try connection.query("""
	select
	       _name,
		age,
		sex
	from animals
	where sex = 'M';
""")

gives you

<ResultSet: { chunks: 0; rows: 0; columns: 3; layout: (
	_name DATABASETYPE.VARCHAR,
	age DATABASETYPE.INTEGER,
	sex DATABASETYPE.VARCHAR
);>