SELECT * FROM mytable WHERE path = '/my/path/to/file/isthis.dat'; #### SELECT * FROM mytable WHERE md5(path) = md5('/my/path/to/file/isthis.dat');