MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mapping(FILTER INT, id INT, F1 TEXT, F2 TEXT)
UPDATE mapping 
SET FILTER = 0 
WHERE CONCAT(F1, F2) NOT LIKE '%searchTerm%';

Rows matched: 0  Changed: 0  Warnings: 0


UPDATE mapping 
SET FILTER = 0 
WHERE id IN(SELECT id FROM mapping WHERE CONCAT(F1, F2) NOT LIKE '%searchTerm%');

Rows matched: 0  Changed: 0  Warnings: 0