[sqlite] Concat two fields for LIKE query?

[Andrés G. Aragoneses]

Schema:

CREATE TABLE SomeTable (
  ID               INTEGER NOT NULL PRIMARY KEY,
  Path             TEXT,
  FileName         TEXT
)

Content (2 rows):
1       /home/user/     File.mp3
2       /home/user/M/   File.mp3


My query, which I want to make it return the first row:

SELECT * FROM SomeTable WHERE Path+FileName LIKE '%user/File%'


Is there any way to do this?

Thanks!

        Andrés

-- 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users