MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test1 (
  cText VARCHAR(20),
  cText2 VARCHAR(20)
);
INSERT INTO test1 VALUES
  ('Hello-World', 'Test'),
  ('HelloWorld', 'Test-'),
  ('HelloWorld', 'Test');
SET @query = '';
SELECT CONCAT('SELECT * FROM test1 WHERE ',GROUP_CONCAT(C.COLUMN_NAME SEPARATOR ' LIKE ''%-%'' OR '), ' LIKE ''%-%''')  FROM INFORMATION_SCHEMA.COLUMNS C WHERE C.TABLE_NAME = 'test1' INTO @query;
PREPARE stmtSearch FROM @query;
EXECUTE stmtSearch;
DEALLOCATE PREPARE stmtSearch;


cText
cText2


Hello-World
Test

HelloWorld
Test-


SELECT CONCAT('SELECT * FROM test1 WHERE ',GROUP_CONCAT(C.COLUMN_NAME SEPARATOR ' LIKE ''%-%'' OR '), ' LIKE ''%-%''')  FROM INFORMATION_SCHEMA.COLUMNS C WHERE C.TABLE_NAME = 'test1'


CONCAT('SELECT * FROM test1 WHERE ',GROUP_CONCAT(C.COLUMN_NAME SEPARATOR ' LIKE ''%-%'' OR '), ' LIKE ''%-%''')


SELECT * FROM test1 WHERE cText LIKE '%-%' OR cText2 LIKE '%-%'