You can use the DISTINCT clause to filter the distinct entries in a table:
mysql> SELECT DISTINCT title FROM titles;+--------------------+| title |+--------------------+| Senior Engineer || Staff || Engineer || Senior Staff || Assistant Engineer || Technique Leader || Manager |+--------------------+7 rows in set (0.30 sec)