search = search.filter(!F.col("Name").contains("ABC"))

search = search.filter(F.not(F.col("Name").contains("ABC"))

Both methods fail due to syntax error could you please help me filter rows that does not contain a certain string in pyspark.

^ SyntaxError: invalid syntax