SELECT file.FileID WHERE file.FileID=file_keyword.FileID AND (file_keyword.Keyword LIKE '%ABC%' AND file_keyword.Keyword LIKE '%XYZ%');

SELECT A.FileID, A.Name FROM file AS A
WHERE EXISTS ( SELECT B.FileID FROM file_keyword AS B
WHERE A.FileID = B.FileID AND B.Keyword LIKE '%ABC%'
AND EXISTS   ( SELECT B.FileID FROM file_keyword AS B
WHERE A.FileID = B.FileID AND B.Keyword LIKE '%XYZ%'
))

SELECT f.FileID, f.Name 
FROM `File` AS f
INNER JOIN `File_Keyword` AS fk1
    ON f.`FileID` = fk1.`FileID`
    AND fk1.`Keyword` LIKE '%key1%'
INNER JOIN `File_Keyword` AS fk2
    ON f.`FileID` = fk2.`FileID`
    AND fk2.`Keyword` LIKE '%key2%'

<?php
$searches = array ("saloon", "diesel", "blue");
$fileID = 123;
$count = 0;
$alias = "";
$sql = "SELECT f.FileID, f.Name FROM `File` AS f ";
foreach ($searches as $search) {
    $count ++;
    $alias = "fk".$count;
    $sql .= "INNER JOIN `File_Keyword` AS ".$alias
        ." ON f.`FileID` = ".$alias.".`FileID`
    AND ".$alias.".`Keyword` LIKE '%".$search."%' ";
}
$sql .= "WHERE f.`FileID` = ".$fileID;
echo ($sql);
?>

SELECT f.`file_id`, f.`name`
FROM `file` AS f
WHERE f.`file_id` NOT IN(
    SELECT fi.`file_id` 
    FROM `file` AS fi
    INNER JOIN `file_keyword` AS fki
        ON fi.`file_id` = fki.`file_id`
    WHERE fki.`keyword` NOT IN('first', 'second', 'third')
);

$keywords = array ("first", "second", "third");
$keyword_list = implode(", ", $keywords);
 
$sql = <<<SQL
SELECT f.`file_id`, f.`name`
FROM `file` AS f
WHERE f.`file_id` NOT IN(
    SELECT fi.`file_id` 
    FROM `file` AS fi
    INNER JOIN `file_keyword` AS fki
        ON fi.`file_id` = fki.`file_id`
    WHERE fki.`keyword` NOT IN({$keyword_list})
);
SQL;
 
echo $sql;

INSERT INTO `file`(`name`) VALUES ('File1'), ('File2');
 
INSERT INTO `file_keyword`(`file_id`, `keyword`)
VALUES
    (1, 'first'), (1, 'second'),
    (2, 'third'), (2, 'fourth');