String nach einem Teilstring durchsuchen
| ID | 237 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | MySQL |
| PlGroup | Strings |
| PlItemTitle | String nach einem Teilstring durchsuchen |
| Code | SELECT myString ,locate('#',myString,5) AS findPosition -- Result is: 8 ,left(myString,locate('#',myString,2)-1) AS ExtractedString -- Result is: abc ,left(myString,locate('#',myString,5)) AS ExtractedString -- Result is: abc#def# FROM ( SELECT 'abc#def#ghj' AS myString ) dummyString |
| Result Example |