Get 3-letter substrings from the dept column : SUBSTRING « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. SUBSTRING

Get 3-letter substrings from the dept column

      
mysql>
mysql> CREATE TABLE IF NOT EXISTS party
    -> (
    ->   id     INT     AUTO_INCREMENT PRIMARY KEY,
    ->   dept CHAR(10), name CHAR(25)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> # insert 3 records into the "party" table
mysql> INSERT INTO party (dept, name)   VALUES ("accounts", "Graham Miller");
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO party (dept, name)   VALUES ("sales", "Gary Miller");
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO party (dept, name)   VALUES ("production", "Graham Wallace");
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> # get 3-letter substrings from the dept column
mysql> SELECT SUBSTRING(dept, 1, 3) FROM party;
+-----------------------+
| SUBSTRING(dept, 1, 3) |
+-----------------------+
| acc                   |
| sal                   |
| pro                   |
+-----------------------+
3 rows in set (0.00 sec)

mysql>
mysql> # delete this sample table
mysql> DROP TABLE IF EXISTS party;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

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 the numeric middle part by beginning with the ID, then stripping off the rightmost suffix