SQLite query

1

When using the addon SQLite web UI, I’m having trouble with a query.

‘’’
Select *
From States
Where entity_id like ‘sensor.beehiveweight’;
‘’’

I always get the error “no such column ‘sensor.beehiveweight’”

I’ve tried double quotes, = … seems it always things I’m specifying a column name not
Text to compare. Am I missing some syntax? I can successfully use the where statement on integer Columns but can’t seem to figure how to format it for searching a VARCHAR column.

2

Try:

... like "%sensor.beehiveweight%"

1 Like