How to use the regexp_instr function in mysql-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

How to use the regexp_instr function in mysql

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

May 29, 2023 am 08:25 AM

mysql regexp_instr

1. The function returns the substring position matching the pattern pat in the string expr. If no matching substring is found, 0 is returned.

2. If expr or pat is NULL, the function returns NULL. Character positions start from 1.

Optional parameters:

pos means starting to search from the specified position of the string expr. By default, matching starts from the 1st character.

occurrence means how many matching results are returned. By default, the position of the first matched substring is returned.

return_option indicates the type of return location. If this parameter is 0 (the default value), the position of the first character of the substring is returned; if this parameter is 1, the position of the first character after the substring is returned.

match_type indicates the matching method, and the parameters are consistent with the REGEXP_LIKE() function above.

Example

mysql> SELECT REGEXP_INSTR(&#39;dog cat dog&#39;, &#39;dog&#39;);
+------------------------------------+
| REGEXP_INSTR(&#39;dog cat dog&#39;, &#39;dog&#39;) |
+------------------------------------+
|                                  1 |
+------------------------------------+
mysql> SELECT REGEXP_INSTR(&#39;dog cat dog&#39;, &#39;dog&#39;, 2);
+---------------------------------------+
| REGEXP_INSTR(&#39;dog cat dog&#39;, &#39;dog&#39;, 2) |
+---------------------------------------+
|                                     9 |
+---------------------------------------+
mysql> SELECT REGEXP_INSTR(&#39;aa aaa aaaa&#39;, &#39;a{2}&#39;);
+-------------------------------------+
| REGEXP_INSTR(&#39;aa aaa aaaa&#39;, &#39;a{2}&#39;) |
+-------------------------------------+
|                                   1 |
+-------------------------------------+
mysql> SELECT REGEXP_INSTR(&#39;aa aaa aaaa&#39;, &#39;a{4}&#39;);
+-------------------------------------+
| REGEXP_INSTR(&#39;aa aaa aaaa&#39;, &#39;a{4}&#39;) |
+-------------------------------------+
|                                   8 |
+-------------------------------------+

Copy after login

The above is the detailed content of How to use the regexp_instr function in mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn