I´m a newbie in the SQL world and I code with just the simple insert, select, delete and update.
So... I have a table with a column named "market" that has a list of cryptocoins... like this...
market
-------
EOS/ETH
EOS/BTC
XMR/BTC
LTC/BTC
DASH/ETH
...
I need to select * from this table where the string before the '/' is equal to each other but after the '/' goes ETH and BTC.:
- the string before the '/' is equal to each other but after the '/' goes ETH and BTC.
- There is a column named exchange that I want to filter too. In this example would be all this coins where exchange = 'bittrex'
In this example the result would be:
EOS/ETH
EOS/BTC
Can anyone help?
