title: Using LIKE operator for multiple words in PySpark
body: <p>I have a DataFrame <code>df</code> in <code>PySpark</code>, like a one shown below -</p>
  
  <pre><code>+-----+--------------------+-------+
  |   ID|           customers|country|
  +-----+--------------------+-------+
  |56   |xyz Limited         |U.K.   |
  |66   |ABC  Limited        |U.K.   |
  |16   |Sons &amp; Sons         |U.K.   |
  |51   |TÜV GmbH            |Germany|
  |23   |Mueller GmbH        |Germany|
  |97   |Schneider AG        |Germany|
  |69   |Sahm UG             |Austria|
  +-----+--------------------+-------+
  </code></pre>
  
  <p>I would like to keep only those rows where <code>ID</code> starts from either 5 or 6. So, I want my final dataframe to look like this -</p>
  
  <pre><code>+-----+--------------------+-------+
  |   ID|           customers|country|
  +-----+--------------------+-------+
  |56   |xyz Limited         |U.K.   |
  |66   |ABC  Limited        |U.K.   |
  |51   |TÜV GmbH            |Germany|
  |69   |Sahm UG             |Austria|
  +-----+--------------------+-------+
  </code></pre>
  
  <p>This can be achieved in many ways and it's not a problem. But, I am interested in learning how this can be done using <code>LIKE</code> statement. </p>
  
  <p>Had I only been interested in those rows where <code>ID</code> starts from 5, it could have been done easily like this -</p>
  
  <pre><code>df=df.where("ID like ('5%')")
  </code></pre>
  
  <p><strong>My Question:</strong> How can I add the second statement like <code>"ID like ('6%')"</code> with <code>OR - |</code> boolean inside <code>where</code> clause? I want to do something like the one shown below, but this code gives an error. So, in nutshell, how can I use multiple boolean statement using <code>LIKE and .where</code> here  -</p>
  
  <pre><code>df=df.where("(ID like ('5%')) | (ID like ('6%'))")
  </code></pre>