<div>
Try this:<br />

<pre><code id="code-20-39990045-1">SELECT column FROM table WHERE column REGEXP '[A-F0-9]{8}:[A-F0-9]{8}'</code></pre>
HTH,<br />
Dan
</div>


Try this:


SELECT column FROM table WHERE column REGEXP '[A-F0-9]{8}:[A-F0-9]{8}'

HTH,
Dan

<div>
No need for that Terry.<br />
<br />
Can the OP please post the result of compiling UDF-regexp with a modern (&gt;5.5) MySQL install?<br />
It's over 7 years old so it would be nice to know if it's still usable.
</div>


No need for that Terry.

Can the OP please post the result of compiling UDF-regexp with a modern (>5.5) MySQL install?
It's over 7 years old so it would be nice to know if it's still usable.

<div>
<div class="content wysiwyg-content">
I have lots of text in a column (mediumtext) with lots of rows. &nbsp;I need to find the position of a substring like:<br />
C82564F1:0008A56C<br />
where<br />
- the string is always that length, 17 bytes<br />
- it always includes a colon in the 9th position<br />
- each of the 16 other characters are a 0 to 9 or A to F (i.e. a HEX)<br />
- it won't have a /n or /t or any other special characters in it<br />
Can I do this with a single query or is there an efficient way to do that with a function?<br />
Thank you
</div>
</div>


I have lots of text in a column (mediumtext) with lots of rows.  I need to find the position of a substring like:
C82564F1:0008A56C
where
- the string is always that length, 17 bytes
- it always includes a colon in the 9th position
- each of the 16 other characters are a 0 to 9 or A to F (i.e. a HEX)
- it won't have a /n or /t or any other special characters in it
Can I do this with a single query or is there an efficient way to do that with a function?
Thank you

mySQL syntax help for a query

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.