As you can imagine this comes from wordpress.

i’ve this table

ID | customID | column1 | column2

1      8      _item    item number

2      8      _price    item price

3      9      _item    item number

4      9      _price    item price

i need a select to export this

CustomID | _price | _item |

8       item price(from col2)    item number(from col2)
9       item price(from col2)    item number(from col2)

is it possible? the value _price and _item should be shown as columns with values from column2. i spent the whole day thinkin about it

thanks for any help

Read more here: Select values from the same column


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: