I'm not entirely sure how to properly write a select query that will select a value from a table where two particular values are found in the same row.
SELECT value FROM table WHERE id=1 AND field=2
What's the correct syntax?
Asked
Active
Viewed 354 times
0
-
http://www.w3schools.com/sql/sql_and_or.asp . Remember to add quotes to the values : id='1' – Jose Manuel Abarca Rodríguez Jul 01 '15 at 22:15
-
2Have you tried what you have there? – Don't Panic Jul 01 '15 at 22:16
-
1quotes only required if the field types are strings, and they don't look like strings to me – Jul 01 '15 at 22:17
-
Thanks guys and thanks for the link jose, I was missing the quotes. – nickyb Jul 01 '15 at 22:17
-
1this `1`and `2` are integer or string? if integer then syntax is correct. if string then add quotes arround them. – Alive to die - Anant Jul 01 '15 at 22:17
1 Answers
-1
select * from table_name where id=1 and name='any' add quotes for string value only
mohammad haris
- 145
- 14
-
2not the downvoter, but `from column_name`? not a good example for a table name as it could confuse new coders. probably better to use `table_name` for clarity. – Sean Jul 01 '15 at 22:24