How to save condition to database

Asked Mar 22 '21 at 17:19

Active Mar 22 '21 at 20:52

Viewed 315 times

I have database. there is table where is column. and column contains conditions > 10, < 10.

And I want to build procedure, that will create a select in loop.

How I can take condition from table and put it in SELECT * FROM TABLE WHERE @condition@?

edited Mar 22 '21 at 20:52

asked Mar 22 '21 at 17:19

Raby Alex

5

Please tag at most one RDBMS. – David Browne - Microsoft Mar 22 '21 at 17:21
Will the condition always use the same column(s)? – Error_2646 Mar 22 '21 at 17:25
Sounds like a recipe for SQL injection, unless the values in the column can really be trusted as well as sanitized.. – Mike Christensen Mar 22 '21 at 17:28
Are all conditions known when writing the query or can there be conditions added and/or removed all the time? (In the first case you can write the query straight away. In the second case you must build the query dynamically at run time.) What DBMS are you asking this for? – Thorsten Kettner Mar 22 '21 at 17:48
2

This sounds like a bad design. I would re-think the application. – Gordon Linoff Mar 22 '21 at 18:29

0 Answers0