SUBSTRING(, ) : SUBSTRING « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. SUBSTRING

SUBSTRING(, )

     
mysql>
mysql> SELECT SUBSTRING('cats and dogs', 10);
+--------------------------------+
| SUBSTRING('cats and dogs', 10) |
+--------------------------------+
| dogs                           |
+--------------------------------+
1 row in set (0.00 sec)








Related examples in the same category

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