Databases
StackOverflow2013
Postsdbo
POmySQL Regexp with square brackets
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmySQL Regexp with square brackets
    primarykey
    data
    text
    <p>I am trying to match strings like '[sometext&lt;someothertext&gt;]' (i.e., left square bracket, text, left angle bracket, text, right angle bracket, right square bracket) within a column in mySQL. Originally I used the following query (notice that since regex queries are escaped twice in mySQL, you must use two backslashes where you would normally use one):</p> <pre><code>SELECT * FROM message WHERE msgtext REGEXP '\\[(.+)?&lt;(.+)?&gt;\\]' </code></pre> <p>This query received no errors, but it returned things I didn't want. Instead of the (.+), I wanted [^\]] (match everything except a right square bracket). When I changed the query, I got the following error: "Got error 'repetition-operator operand invalid' from regexp"</p> <p>After reading through the mySQL documentation <a href="http://dev.mysql.com/doc/refman/5.1/en/regexp.html" rel="nofollow noreferrer">here</a>, it states "To include a literal ] character, it must immediately follow the opening bracket [." Since I want "^\]" instead of "]", is this even possible since the bracket can't be the first character after the opening bracket? Below are some of the queries I have tried which get the same error listed above:</p> <pre><code>SELECT * FROM message WHERE msgtext REGEXP '\\[([^\\]]+?)&lt;([^\\]]+?)&gt;\\]' SELECT * FROM message WHERE msgtext REGEXP '\\[[^\\]]+?&lt;[^\\]]+?&gt;\\]' SELECT * FROM message WHERE msgtext REGEXP '\\[[^[.right-square-bracket.]]]+?&lt;[^[.right-square-bracket.]]]+?&gt;\\]' </code></pre> <p>UPDATE:</p> <p>The following query runs without errors, but does not return any rows even though I know there are columns which match what I am looking for (based on my original query at the top):</p> <pre><code>SELECT * FROM message WHERE msgtext REGEXP '\\[([^\\]]+)?&lt;([^\\]]+)?&gt;\\]' </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRick
    1. USRick
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POmySQL Regexp with square brackets
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload