mysql

A Khan

need to convert oracle instr() function in mysql

Dave Stokes-MySQL Community Team-Oracle

MySQL :: MySQL 5.7 Reference Manual :: 12.5 String Functions

INSTR(<em class="replaceable" style="font-size: 15.8517px; background: transparent;"><code style="padding: 1px; font-size: 15.0591px; color: inherit; font-weight: bold; font-family: 'Courier New', Courier, fixed, monospace; background-color: inherit; background-position: initial;">str,substr)

Returns the position of the first occurrence of substring substr in string str. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed.

mysql> SELECT INSTR('foobarbar', 'bar'); -> 4 mysql> SELECT INSTR('xbar', 'foobar'); -> 0 

This function is multibyte safe, and is case sensitive only if at least one argument is a binary string.

A Khan

please reply on that question

Dave Stokes-MySQL Community Team-Oracle

MySQL :: MySQL 5.7 Reference Manual :: 12.5 String Functions

INSTR(<em class="replaceable" style="font-size: 15.8517px; background: transparent;"><code style="padding: 1px; font-size: 15.0591px; color: inherit; font-weight: bold; font-family: 'Courier New', Courier, fixed, monospace; background-color: inherit; background-position: initial;">str,substr)

Returns the position of the first occurrence of substring substr in string str. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed.

mysql> SELECT INSTR('foobarbar', 'bar'); -> 4 mysql> SELECT INSTR('xbar', 'foobar'); -> 0 

This function is multibyte safe, and is case sensitive only if at least one argument is a binary string.