MYSQL SELECT only one column from all rows in table

Question

I need to select all values from all rows by one column in my table. I have

ID       TAGS
1        girls, womens, cars
2        girls, world, flowers
3        weapons, cars, boys

so after SQL I should get an array:

array('girls', 'womens', 'cars', 'girls', 'world', 'flowers', 'weapons', 'cars', 'boys')

so how my sql should look like?

This is not possible if you have a multi valued field. there's a bit of post processing you need to do with your query result. — Jayaram, Nov 07 '13 at 17:31
how the query should look like for getting all tags from all rows? after then i think I could dekete similar values from array — Žydrius Nežydras, Nov 07 '13 at 17:39
no, there can be 100 keywords. It be enough for me just get all values, similar too — Žydrius Nežydras, Nov 07 '13 at 17:42
The amended question can be solved with `SELECT GROUP_CONCAT(tags SEPARATOR ' ') FROm tags;` — Strawberry, Nov 07 '13 at 17:48

score 5 · Answer 1 · edited Jun 20 '20 at 09:12

5

Never, never, never store multiple values in one column.

Like you see now this will only give you headaches. Normalize your table.

USER_ID  TAG
1        girls
1        women
1        cars
2        girls
...

After that you could select your desired result like this

select group_concat(distinct tag)
from your_table

edited Jun 20 '20 at 09:12

Community

answered Nov 07 '13 at 17:32

juergen d

If you're using wordpress or similar, then I'm afraid it's pretty much unavoidable. – Strawberry Nov 07 '13 at 17:37
this is not an option, becouse all actions is in my news table, where is columns: id, name, url, tags. So I can't make other table for tags – Žydrius Nežydras Nov 07 '13 at 17:37

score 0 · Answer 2 · edited May 23 '17 at 11:57

0

edited May 23 '17 at 11:57

Community

answered Nov 07 '13 at 17:32

Wasif

score 0 · Answer 3 · edited May 23 '17 at 11:50

0

I can atleast give a sample solution:

use Cursor or something to traverse through each row of data
split the data (there are couple of split example found in internet) sample example, Split string in SQL
put the value in a temp table
finally select distinct from the table

someone can put these example and make a solution.

edited May 23 '17 at 11:50

Community

answered Nov 07 '13 at 18:30

saif