How to pass values from a file to a query in shell script?

[Aniket sonmale]

i need to pass values to a query in my shell script.


my file will contain data as below.

3123213
1234133
4423434
4242343
.
.
.and so on.

there is a query in my shell script say

"select * from TABLE where col='A'"

now i need to pass values from my file in palce of 'A' one by one in a loop.