| Code: |
SELECT
SUBSTR(introtext,LOCATE('Name:',introtext) + LENGTH('Name:'),LOCATE('<br',introtext,LOCATE('Name:',introtext)) - LOCATE('Name:',introtext) - LENGTH('Name:')) AS Name,
|
Sorry again, this code works perfectly with the Latin alphabet but with Russian characters does not work, Could you modify the code.
Tried by your example to do this stuff, but it does not work:
| Code: |
MB_SUBSTR(introtext,LOCATE('russian symbols:',introtext) + LENGTH('russian symbols:'),LOCATE('<br',introtext,LOCATE('russian symbols:',introtext)) - LOCATE('russian symbols:',introtext) - LENGTH('russian symbols:'),'UTF-8') AS Name,
|
