SUBSTRING « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. SUBSTRING
1.SUBSTRING(, )
2.SUBSTRING(, , )
3.Sorting by Variable-Length Substrings
4.Create Initial name with substr function
5.In some cases, pattern matches are equivalent to substring comparisons.
6.SUBSTRING( ) function takes a string and a starting position, returning everything to the right of the positio
7.Substrings can be used to perform comparisons.
8.Sort using combinations of substrings
9.Get 3-letter substrings from the dept column




10.Get the numeric middle part by beginning with the ID, then stripping off the rightmost suffix