Sql query to search the contents of all attachment including file.

[Kalyan Kumar Das]

I need a sql query to search the contents of all attachments, including file attachments.I am using mysql database.

Please suggest. 

[Payne]

SQL cannot be used to search the contents of attachments; only attachment metadata is stored in the database; the attachments themselves are stored on the file system.

[Rilwan Ahmed]

Hi @Kalyan Kumar Das ,

if you are looking to know all tickets which has attachments, then use JQL as below

project = "ABC" and attachments is not EMPTY