I've looked online and found a few references saying that text fields have whitespace but that varchar fields will strip the whitespace, but this does not seem to be the case.
Strangely, my output looks like the genres are centered in the field (or maybe that is just how it display on output from command line mysql.
Here is what the output looks like (edit- for some reason the centering effect I get in my output gets cleaned up when I submit to the forum).
Is there any way to clean this up?
Expand|Select|Wrap|Line Numbers
- mysql> SELECT genre FROM artists WHERE genre LIKE '%Rock%' LIMIT 0,5;
- +-----------------------------------------------------------+
- | genre |
- +-----------------------------------------------------------+
- | 2-step / Acousmatic / Tape music / Classic Rock |
- | 2-step / Acousmatic / Tape music / Rock |
- | 2-step / Acoustic / Rock |
- | 2-step / Alternative / Classic Rock |
- | 2-step / Alternative / Classic Rock |
- +-----------------------------------------------------------+
- 5 rows in set (0.04 sec)