i am having 9 fields in sql table.I want to check for all the fields the condition 'completed' and 'missing' what is the short way to check?
2006-07-27 21:55:02 · 4 answers · asked by ooxy 1 in Computers & Internet ➔ Programming & Design
try this i am not sure
select * from table where
field1 or field2 or field3... ="completed"
select * from table where
field1 or field2 or field3... ="missing"
2006-07-28 01:14:35 · answer #1 · answered by kanna 3 · 0⤊ 0⤋
select * from table_name;
too check all the fields in a table
2006-07-28 04:59:09 · answer #2 · answered by anti_money 2 · 0⤊ 0⤋
Though ur question is not clear, but i will give a try.
SELECT CASE WHEN F1 = '' THEN 'MISSING' ELSE 'COMPLETED' END FROM TABLE
2006-07-28 05:10:56 · answer #3 · answered by saini160179 2 · 0⤊ 0⤋
clarify the question. Not able to get wat the ques is.
2006-07-28 05:00:09 · answer #4 · answered by Cool Guy 2 · 0⤊ 0⤋