Adjit Adjit - 1 year ago 74
SQL Question

SQL Select all rows with specific value

Trying to select all rows with the value

in the column

This is my current query -

SELECT * from MyTable
Where ORMSTRID = "33487MO"

But it gives me an error that is saying
Invalid column name '33487MO'

SELECT * from MyTable

shows me all of the rows and columns from the table, and
is definitely the column name.

Answer Source

You should use single quote with string data According your example your query should be:

select * from mytable
where ORMSTRID like '33487MO'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download