title: SQL equivalent of 'like' operator in Python?
body: <p>Beginner here again. I've checked out the other similar question on stackoverflow but the response is too confusing. This here is the original question given by our Python instructor at college:</p>
  <blockquote>
  <p>Your course instructor asked you to write programming which takes the input as a string from the user. Now your task is to find the first appearance of the substring 'not' and 'poor' from a given string, if 'not' follows the 'poor', replace the whole 'not'...'poor' substring with 'good'. Return the resulting string.</p>
  </blockquote>
  <blockquote>
  <p>E.g.,
  String: 'The lyrics is not that poor!'
  Result: 'The lyrics is good!'</p>
  </blockquote>
  <blockquote>
  <p>String: 'The lyrics is poor!'
  Result: 'The lyrics is poor!'</p>
  </blockquote>
  <p>What I understand from the question is that we have to find and replace the part of the string starting from 'not' to 'poor', so I had the idea of using something similar to the &quot;LIKE&quot; operator in MySQL. But I cannot find any alternatives. Please help.</p>