Hi guys When I tried to run ```EXISTS SELECT size from file

Question

Hi guys When I tried to run ```EXISTS SELECT size from file where path = tmp et txt ``` I get this error Error near EXISTS syntax error Maybe do you have a different solution instead of EXISTS

seph · Answer

Osquery uses SQLite as the underlying engine So whatever works there will work What is exists supposed to do

ET · Answer

I want to know if file EXISTS

fritz · Answer

fritz · Answer

Likewise you could write ```SELECT true AS is present FROM file WHERE path = tmp et txt ```

fritz · Answer

If you wanted to return a boolean row both when the file was present missing you could employ `CASE` logic as follows ```SELECT CASE WHEN SELECT 1 FROM file WHERE path = tmp et txt THEN true ELSE false END AS file present```

ET · Answer

Great idea Thanks again