Shell Programming and Scripting

select * from table where name in ('${name});

3" - 11" DCBA-1234
5"-8" ABC MNOP-3765
8"-16" LMNOP ABCD-0302
ABC XYZ JKLM-1212
XYZ-1673

for name in `cat file.txt`
do
select * from table where name in ('${name});
done

$ while read LINE; do echo "select * from table where name in ('$LINE');"; done < infile
select * from table where name in ('3" - 11" DCBA-1234');
select * from table where name in ('5"-8" ABC MNOP-3765');
select * from table where name in ('8"-16" LMNOP ABCD-0302');
select * from table where name in ('ABC XYZ JKLM-1212');
select * from table where name in ('XYZ-1673');

awk -v q=\' '
{
     s ? s=s ORS q $0 q : s=q $0 q
}
END{
     printf("select * from table where name in (%s);\n", s)
}
' ORS=, infile

select * from table where name in ('3" - 11" DCBA-1234','5"-8" ABC MNOP-3765','8"-16" LMNOP ABCD-0302','ABC XYZ JKLM-1212','XYZ-1673');