Can anyone help me with the easy way of storing keywords in a mysql database field. What type to use? Text? Nvarchar?
Data in the field looks like this: Traveling , Movies , Sport, Painting
I want to be able to later get that field and list on a page, probably need any kind of .trim to remove the comas and put data in a list?
I apprecate all help i can get, database is already designed so i dont want any suggestions where i create one to many relations and stuff, just a easy way of storing different words in a field and get all words from that field by query later without the
comas.
gabbana
0 Points
2 Posts
Store keywords separated by coma in a field in mysql database
Dec 02, 2012 11:52 AM|LINK
Can anyone help me with the easy way of storing keywords in a mysql database field. What type to use? Text? Nvarchar?
Data in the field looks like this: Traveling , Movies , Sport, Painting
I want to be able to later get that field and list on a page, probably need any kind of .trim to remove the comas and put data in a list?
I apprecate all help i can get, database is already designed so i dont want any suggestions where i create one to many relations and stuff, just a easy way of storing different words in a field and get all words from that field by query later without the comas.