I just recently started learning SQL, and I tried to find a random string in the table -
which might have accidentally put into a wrong column and I tried to find the value in the table
and I used to following SELECT like so;
SELECT * FROM tablename
WHERE 'val' IN (column1, column2, column3, column4, ...)
我的问题是，您可以在表内搜索而不必在括号中命名所有列名吗？
先感谢您！
“是否可以在表中搜索而不必在括号中命名所有列名？”
您不需要在括号中添加列名，而是在要搜索的括号中添加值。因此，您的查询应如下所示：
即列名称在左侧，值在右侧。