CODEWITHSUNDEEP
sql
jskidd3
jskidd3

Reputation: 4783

Use SQL to select all data in row where first column equals something

Is it possible to use SQL to select every piece of data in a row where the first column in the row is equal to something?

Thanks

Upvotes: 0

Views: 1328

Answers (3)

Learner
Learner

Reputation: 4004

IF I understand it correctly, you want to retrieve data based on just simple where condition:

Select * From Table_Name Where First_Column_Name = Something

However, I highly suggest you to go through the SQL basics because asking questions like this won't get you anywhere.

Some Basic Resources:

Question Specific: http://www.w3schools.com/sql/sql_where.asp

General: http://www.w3schools.com/sql/default.asp

Upvotes: 1

Tim Schmelter
Tim Schmelter

Reputation: 460238

SELECT T.* FROM dbo.TableName T WHERE FirstColumn = @Something

Upvotes: 1

Kris Gruttemeyer
Kris Gruttemeyer

Reputation: 872

If I'm understanding your question, it's just a simple SELECT statement.

Try this:

SELECT * from MyTable WHERE Field1 = 'MatchThis'

Upvotes: 1

Related Questions