Help solve a SQL statement problem

月月如丝

Help solve a SQL statement problem: The table name is fixed (student), the field name is uncertain (name, class, Id ...), and the data of the field is not fixed. Now I want to find the data by a query. Use the variable condition to indicate the field name value How should I write a SQL statement like the query condition of the selected field?

xing_532

Configure with strings

yfacmilan

sql = "select" + condition + "from student where" + value

yfacmilan

sql = "select"&condition&"from student where"&value

hangcool

sql = "SELECT" + condition + "FROM STUDENT WHERE" + VALUE
Pay attention to spaces

talentzj

select *
from
student
where condition = 'value'
go

月月如丝

Thank you, the problem is solved

月月如丝

The problem is solved

jys5090

Use variables to join.