pacodelumberg
pacodelumberg

Reputation: 2274

sql statement to check the length of an attribute value in sqlite3 python

Is there a way to write a query that returns the results according to the length of a specific attribute value in sqlite3 ?

For instance I have table X as :

id statements

1 "new-york library"

2 "hudson river"

...

how could we write an sql query for the question: " Get me the statements that have character-length less than 13".

Upvotes: 0

Views: 1591

Answers (1)

juergen d
juergen d

Reputation: 204756

select statements 
from X
where length (statements) < 13

Upvotes: 3

Related Questions