title: MYSQL #1139 - Got error 'repetition-operator operand invalid' from regexp MYSQL
body: <p>I'm having trouble using a regular expression to select some results from my MySQL table.
  I'm using this query</p>
  
  <pre><code>select t.City, t.Mall, t.Number_Phone,  t.Number_Phone rlike '^((\+380){1}(\(542\)){1}[0-9]{6}){1}&amp;' as test from (select c.name as City, m.name as Mall, p.text_value as Number_Phone from objects c cross join objects m left join params p on (m.object_id=p.object_id and p.attr_id=11) where (c.object_type_id=23 and m.object_type_id=25)) as t
  </code></pre>
  
  <p>And it says</p>
  
  <pre><code>#1139 - Got error 'repetition-operator operand invalid' from regexp
  </code></pre>
  
  <p>Regular exp:</p>
  
  <pre><code>'^((\+380){1}(\(542\)){1}[0-9]{6}){1}&amp;'
  </code></pre>
  
  <p>Thank you in advance.</p>