Grouping Two Columns Together
Posted: Sun Jul 10, 2011 7:28 am
I have a database which stores the information of MP3 files.
This is my current database with an example row:
____________________
| `` title ` | ` artist ` |
----------------------------
| Gold Dust | DJ Fresh |
----------------------------
Is there a way to temporarily group title and artist together like this:
______________________________________
| `` title ` | ` artist ` | ` my_new_row ` |
-----------------------------------------------------
| Gold Dust | DJ Fresh | Gold Dust DJ Fresh |
-----------------------------------------------------
I need to group them like this so I can match keywords in both title and artist. Thanks for your help!
This is my current database with an example row:
____________________
| `` title ` | ` artist ` |
----------------------------
| Gold Dust | DJ Fresh |
----------------------------
Is there a way to temporarily group title and artist together like this:
______________________________________
| `` title ` | ` artist ` | ` my_new_row ` |
-----------------------------------------------------
| Gold Dust | DJ Fresh | Gold Dust DJ Fresh |
-----------------------------------------------------
I need to group them like this so I can match keywords in both title and artist. Thanks for your help!