blocks|key|2648190|text|你的问题允许三种解释：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2648191|SQL+|2648192|您不关心列:从where子句中删除it+(或者一起删除where子句，如果这是唯一的子句)|unordered-list-item|2648193|
|2648194|您想要设置列，但您不关心什么:+Use+WHERE+column+IS+NOT+nULL|offset|length|style|CODE|2648195|2648196|You想要搜索，它还可以显示来自一个简单|2648197|
模板的所有记录：|2648198|entityMap^0|0|0|0|0|K|O|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|Z|8|@$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|13|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|14|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|U|$]]

Your question allow three intrepretations:

<ol>
<li>You don't care about the column: drop the it from the where clause (or drop the where clause alltogether, if this was the only subclause)</li>
<li>You want the column to be set, bit you don't care to what: Use <code>WHERE column IS NOT nULL</code></li>
<li>You want a search, that can also display all records from a simple SQL template: <code>SELECT * FROM table WHERE column LIKE '%$searchterm%'</code></li>
</ol>

blocks|key|2648126|text|SELECT+*+FROM+table|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2648127|如果您是动态生成SQL，那么它是|unstyled|2648128|SELECT+*+FROM+table+WHERE+1=1|2648129|1=1占位符允许您返回所有记录，如果要返回子集或需要其他条件语句，则可以替换为实际条件。|offset|length|style|CODE|2648130|另请参阅|2648131|Why+would+someone+use+WHERE+1=1+AND++in+a+SQL+clause?|2648132|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/242822/why-would-someone-use-where-1-1-and-conditions-in-a-sql-clause^0|0|0|0|0|3|0|0|0|1H|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|11|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|13|8|@$K|14|L|15|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|17|8|@]|9|@$K|18|L|19|1|1A]]|A|$]]|$1|S|3|-4|5|F|7|1B|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

<pre><code>SELECT * FROM table
</code></pre>

If you're generating SQL dynamically, it's

<pre><code>SELECT * FROM table WHERE 1=1
</code></pre>

The <code>1=1</code> placeholder allows you to return all records, or substitute an actual condition if you're returning a subset or need additional conditional statements. 

See Also 
<a href="https://stackoverflow.com/questions/242822/why-would-someone-use-where-1-1-and-conditions-in-a-sql-clause">Why would someone use WHERE 1=1 AND &lt;conditions&gt; in a SQL clause?</a>

blocks|key|1516366|text|对于出于任何原因(可能是动态SQL)而需要查询中的列名的任何人，SELECT+*+FROM+table+WHERE+column+=+column是一个很好的替代方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1516367|这与WHERE+1=1非常相似，但是它包含列名，这是我的解决方案所需要的，可能还有一些其他解决方案也需要列名。|1516368|entityMap^0|W|15|0|2|9|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

For anyone who NEEDS the column name in the query for whatever reason (probably dynamic SQL), a nice alternative would be <code>SELECT * FROM table WHERE column = column</code>

This is very similar to <code>WHERE 1=1</code>, however it includes the column name, which my solution required, and maybe a few others will require as well.

blocks|key|926614|text|一切还是任何事？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|926615|我想你可以使用通配符。|926616|SELECT+*+FROM+table+WHERE+column+LIKE+"%25"|code-block|syntax|javascript|926617|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Everything or anything?

You could use a wildcard I guess.

<pre><code>SELECT * FROM table WHERE column LIKE "%"
</code></pre>

blocks|key|2648428|text|您可以在查询中使用列名本身：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2648429|SELECT+*+FROM+TABLE+WHERE+COLUMN+=+COLUMN|code-block|syntax|javascript|2648430|例如：|2648431|SELECT+*+FROM+Student+WHERE+YEAR+=+YEAR|2648432|或使用辅助参数：|2648433|SELECT+*+FROM+Student+WHERE+YEAR+=+(CASE+WHEN+@year+IS+NOT+NULL+THEN+@year+ELSE+YEAR+END)|2648434|所以你可以保留"=“字符|2648435|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You can use column name itself in your query:

<pre><code>SELECT * FROM TABLE WHERE COLUMN = COLUMN
</code></pre>

for example:

<pre><code>SELECT * FROM Student WHERE YEAR = YEAR
</code></pre>

or by using a Auxiliary parameter:

<pre><code>SELECT * FROM Student WHERE YEAR = (CASE WHEN @year IS NOT NULL THEN @year ELSE YEAR END)
</code></pre>

so you can hold on "=" char

blocks|key|1516430|text|SELECT+*+FROM+table+WHERE+column+=+IF+(?+=+'',+column,+?);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1516431|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT * FROM table WHERE column = IF (? = '', column, ?);
</code></pre>

blocks|key|2648213|text|虽然为时已晚，但可能对其他人有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2648214|你可以试试这个。|2648215|where+
++++isnull([column],+'')+=+CASE+WHEN+@column+IS+NULL+THEN+isnull([column],+'')+ELSE+@column+END+|code-block|syntax|javascript|2648216|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is late but may be helpful to others

You can try this.

<pre><code>where 
 isnull([column], '') = CASE WHEN @column IS NULL THEN isnull([column], '') ELSE @column END 
</code></pre>

blocks|key|926643|text|您是否正在寻找IN+criteria运算符？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|926644|SELECT+*+from+table+where+column+in+(1,2,3,4,5)+or+column+in+('value',+'value2',+'value3');|code-block|syntax|javascript|926645|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Are you perhaps looking for the IN criteria operator?

<pre><code>SELECT * from table where column in (1,2,3,4,5) or column in ('value', 'value2', 'value3');
</code></pre>

blocks|key|2564979|text|嗯，我也有同样的问题，下面的方法解决了我的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2564980|...+where+column+=+case+when+@variable+=+'all'+then+column+else+@variable+end|code-block|syntax|javascript|2564981|2564982|+请记住，您必须始终发送默认值，我将我的默认值设置为‘’。因此，如果我设置@variable+=+'all'，mysql将其读取为：where+column+=+column，这与where+1=1
相同。|blockquote|offset|length|style|BOLD|CODE|2564983|2564984|entityMap^0|0|0|0|1|E|11|H|1U|L|2I|9|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|V|8|@$K|W|L|X|M|N]|$K|Y|L|Z|M|O]|$K|10|L|11|M|O]|$K|12|L|13|M|O]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|R|$]]

Well I had this same issue too and the following solved my problem:

<pre><code>... where column = case when @variable = 'all' then column else @variable end
</code></pre>

<blockquote>
 Keep it in mind that you must always send a default value
 , i set my default value as 'all'. So if i set <code>@variable = 'all'</code>, mysql reads it as :
 <code>where column = column</code> which is the same thing as <code>where 1=1</code>
</blockquote>

blocks|key|2565063|text|我在开发动态组合查询时遇到过这个问题。简而言之，我的解决方案如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2565064|WHERE+(column+=+ANY+(SELECT+distinct+column)+OR+column+IS+NULL)|code-block|syntax|javascript|2565065|这适用于空值，实际上它等同于空的WHERE语句。我使用括号是为了保持使用AND运算符添加更多WHERE选项的能力。|2565066|这意味着：|2565067|select+count("objectId"),+"source"
from+"SomeTable"
where+"createdAt"+>+'2020-07-06'
++++and+("source"+=+any+(select+distinct+"source")+or+"source"+is+null)
++++and+("country"+=+any+(select+distinct+"country")+or+"country"+is+null)
++++and+"channel"+is+not+null
group+by+"source"|2565068|等同于：|2565069|select+count("objectId"),+"source"
from+"SomeTable"
where+"createdAt"+>+'2020-07-06'
++++and+"channel"+is+not+null
group+by+"source"|2565070|这样我就可以做一个查询模板了：|2565071|...
++++WHERE+(column+=+{{filter_value}}+)
...|2565072|并将{{filter_value}}的默认值设置为ANY+(SELECT+distinct+column)+OR+column+IS+NULL)|offset|length|style|CODE|2565073|entityMap^0|0|0|0|0|0|0|0|0|0|P|1B|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1B|8|@$W|1C|X|1D|Y|Z]]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|11|$]]

I've faced this problem while developing dynamically composing query.
Here is my solution in short:
<pre><code>WHERE (column = ANY (SELECT distinct column) OR column IS NULL)
</code></pre>
This works with NULL values and practically it is identical to empty WHERE statement. I use brackets in order to keep the ability to add more WHERE options using AND operator.
It means that this:
<pre><code>select count(&quot;objectId&quot;), &quot;source&quot;
from &quot;SomeTable&quot;
where &quot;createdAt&quot; &gt; '2020-07-06'
 and (&quot;source&quot; = any (select distinct &quot;source&quot;) or &quot;source&quot; is null)
 and (&quot;country&quot; = any (select distinct &quot;country&quot;) or &quot;country&quot; is null)
 and &quot;channel&quot; is not null
group by &quot;source&quot;
</code></pre>
equals to this:
<pre><code>select count(&quot;objectId&quot;), &quot;source&quot;
from &quot;SomeTable&quot;
where &quot;createdAt&quot; &gt; '2020-07-06'
 and &quot;channel&quot; is not null
group by &quot;source&quot;
</code></pre>
So I can make a query template:
<pre><code>...
 WHERE (column = {{filter_value}} )
...
</code></pre>
and set <code>ANY (SELECT distinct column) OR column IS NULL)</code> as default value for {{filter_value}}

blocks|key|1516222|text|如果这对任何人有帮助..。只是为了指出，如果您遇到SELECT+*+FROM之类的问题(可以是特定的，也可以是所有的)，比如过滤内容，您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1516223|SELECT+*+FROM+something+as+s+WHERE+(?1+=+0+OR+?1+=+s.type+=+?1)|offset|length|style|CODE|1516224|这里只是一个为所有人预定义的，所以请随意更改，我在使用JPA存储库和hibernate进行过滤时需要它。由于预准备语句的安全性，您不能像前面的答案所建议的那样在医学上做到这一点。其中?1对应于：|1516225|++Page<Something>+filterSometing(Long+type,Pageable+pageable);|code-block|syntax|javascript|1516226|entityMap^0|0|0|1R|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

If this helps anyone... just to point out, if you have a problem such as SELECT * FROM something WHERE (can be specific or everything) such as filtering stuff, 
you can use 
 <code>SELECT * FROM something as s WHERE (?1 = 0 OR ?1 = s.type = ?1)</code> 
 0 here is a just predefined for all, so feel free to change, i needed this while using JPA repositories with hibernate for filtering. You can't do this medicinally as suggested by a previous answer because of the safety with prepared statements. Where the ?1 corresponds to : 

<pre><code> Page&lt;Something&gt; filterSometing(Long type,Pageable pageable);
</code></pre>

blocks|key|2648510|text|将elvis运算符放入该字段|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2648511|"+.+($variable+==+'selected+value'+?+''+:+"AND+column='"+.+$variable+.+"'+")+.+"|code-block|syntax|javascript|2648512|所以当你选择html页面中的所有选项时，这个%5E%5E字段将不会运行，但是当你选择一些东西时，这段代码将显示为column=‘“.$variable”’。|2648513|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

put elvis operator to that field
<pre><code>&quot; . ($variable == 'selected value' ? '' : &quot;AND column='&quot; . $variable . &quot;' &quot;) . &quot;
</code></pre>
so where u select all in the options in the html page this ^^ field will not run
but when u select something this code will show up like column='&quot;.$variable.&quot;'

blocks|key|2648545|text|您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2648546|WHERE+1|code-block|syntax|javascript|2648547|在其他语言中，1总是正确的。所以你没有过滤器|2648548|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can use
<pre><code>WHERE 1
</code></pre>
1 is like in other language always true. So you have no filter

Is SQL able to do something along the lines of this: <code>SELECT * FROM table WHERE column = everything</code>

SQL WHERE column = everything

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

SQL能做类似这样的事情吗：SELECT * FROM table WHERE column = everything

问SQL WHERE column = everything
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL WHERE column = everythingEN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL WHERE column = everything
EN