pyspark: counter part of like() method in dataframe

Question

Is there any counter method for like() in spark dataframe (something as notLike())?

Or is there any other way to do it except using the traditonal SQL query?

I want to do just the opposite of the following:

df.where(col("_c2").like("XY6%")).show(5)

Answer 1

It worked :)

I had to use the negation operator (~) instead of the 'not' keyword.

df.where(~ col("_c2").like("XY6%")).show(5)

Answer 2

Or you can do :

df.where( col("_c2").like("XY6%") == False ).show(5)