Very simple SQL query on varchar fields with sqlite -


I created a table using this schema using sqlite3:

  vs table monitor Done_files (file_id INTEGER primary key, file_name VARCHAR (32767), original_related_dir_ pathVARCHAR (32767), backup-up_related_dir_ pathVARCHAR (32767), directory_id INTEGER);  

Now, I would like to get all the records where the original _relative_dir_path '.' Is equal to, without 'what I have done is:

  choose from the monitored files * where the original_related_dire_path ='. ';  

The result is not a record, even though I have this record in the table:

  1 | 'P9040479.JPG' | '.' | '| . '| 1  

I read on the web and I did not see any mistake in my syntax ... I also tried to like it. ', But still no results. I am not an expert in SQL, maybe you can see something wrong? Thanks!

I have no problem with the statement.
I have created the table you have mentioned
There was no INSERT with the same values ​​provided by you.
and did the query, and inquired even without any clause.
No problem, so I suspect that when you execute your selection, then you should be connected to the correct database.


Comments