I have a table with a field 'code' . This code is formed in two parts: one before and one after the dot, like all stock-codes (MS.N for Microsoft at Nasdaq for exemple).
I would like to select all stocks on Nasdaq. How can I do this?
"select * from table where code like '%.N'" doesn't work?
PS. I use Postgres.
I would like to select all stocks on Nasdaq. How can I do this?
"select * from table where code like '%.N'" doesn't work?
PS. I use Postgres.