select query in sqlite doesn't return anything

Question

I'm using the Firefox sqlite manager addon and I have a database table named - drinktable. I need to extract all the columns where the title matches a certain string. This is the query I am running right now -

SELECT * FROM drinktable where title = 'First Drink';

But it won't return anything. It just shows the 4 columns in the database, but nothing in those columns. Can someone please tell me why ?

Could it be because no row in first contains 'First Drink' in the drinktable column? — Sergey Kalinichenko
– Sergey Kalinichenko, Commented Jun 29, 2012 at 4:31

Habib · Accepted Answer · 2012-06-29 04:37:06Z

I have a database table named - drinktable.

One thing in your question. Your table name is drinktable and you are querying against first, is it a typo. In SQL Select statement you specify table name after from and column name in where clause

SELECT * FROM drinktable where first = 'First Drink'; Select * from <TableName> where <ColumnName> = 'Value to compare';

If your table name is first and column name is drinktable then chances are that there are now row(s) with column drinktable set to 'First Drink'. You might have spaces or some other characters. Try

SELECT * FROM first where drinktable like '%First Drink%';

EDIT:

Based on your edited question, chances are you have spaces or some other characters, try:

SELECT * FROM drinktable where title like '%First Drink%';

Collectives™ on Stack Overflow

select query in sqlite doesn't return anything

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related