title: Locate Syntax in mysql
body: <p>I'm trying to return all rows that contain a substring in mysql </p>
  
  <p>and here is my code </p>
  
  <pre><code>SELECT        Last_Name, Midle_Name, First_Name, Phone_home
  FROM            contact_info
  LOCATE   (@prefixText, Last_Name)
  </code></pre>
  
  <p>but I'm getting an error.</p>
  
  <p>please help me with the correct syntax for LOCATE in my case.
  Thank you</p>