blocks|key|4016437|text|请参阅“约翰邮报”和随后的评论：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4016438|您需要的MySql将是|4016439|SELECT+*+FROM+mytable+WHERE+mycolumn+REGEXP+BINARY+'[a-z]'
++++++++++++++++++++++++AND+mycolumn+REGEXP+BINARY+'[A-Z]'
++++++++++++++++++++++++AND+mycolumn+REGEXP+BINARY+'[0-9]'|code-block|syntax|javascript|4016440|添加附加|4016441|AND+mycolum+REGEXP+BINARY+'%5E[a-zA-Z0-9]%2B$'|4016442|如果您只想在字符串中使用字母数字|4016443|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Further from Johns Post and subsequent comments:

The MySql you require would be

<pre><code>SELECT * FROM mytable WHERE mycolumn REGEXP BINARY '[a-z]'
 AND mycolumn REGEXP BINARY '[A-Z]'
 AND mycolumn REGEXP BINARY '[0-9]'
</code></pre>

Add additional 

<pre><code>AND mycolum REGEXP BINARY '^[a-zA-Z0-9]+$'
</code></pre>

If you only want Alphanumerics in the string

blocks|key|3155924|text|有了前瞻性断言，您可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3155925|/%5E(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9]).*$/|code-block|syntax|javascript|3155926|update似乎mysql不支持查看周围的断言。|offset|length|style|BOLD|3155927|entityMap^0|0|0|0|6|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

With look-ahead assertion you could do like this:

<pre><code>/^(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9]).*$/
</code></pre>

update: It seems mysql doesn't support look around assertions.

blocks|key|4016329|text|您可以将其分成3种不同的正则表达式来测试每一种情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4016330|[a-z]、[A-Z]和[0-9]|offset|length|style|CODE|4016331|以及这些比赛的结果，你可以达到你想要的结果。|4016332|编辑：|4016333|如果你只想匹配字母数字，你应该按照Ed在评论中的建议做%5E[a-zA-Z0-9]%2B$|4016334|entityMap^0|0|0|5|6|5|C|5|0|0|0|R|E|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]|$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|O|$]]

You could split it up into 3 separate regex to test for each case. 

<code>[a-z]</code>, <code>[A-Z]</code>, and <code>[0-9]</code>

and the results of those matches together, and you can achieve the result you're looking for. 

EDIT:

if you're only looking to match alphanumerics, you should do <code>^[a-zA-Z0-9]+$</code> as suggested by Ed Head in the comments

blocks|key|3133320|text|我的解决办法是找出一个长的表达式，因为我将在所有6种可能性中进行变换--找到的大写字母、小写字母和所需的数字可以排列在字符串中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3133321|%5E(.*[a-z].*[A-Z].*[0-9].*%7C
++.*[a-z].*[0-9].*[A-Z].*%7C
++.*[A-Z].*[a-z].*[0-9].*%7C
++.*[A-Z].*[0-9].*[a-z].*%7C
++.*[0-9].*[a-z].*[A-Z].*%7C
++.*[0-9].*[A-Z].*[a-z].*)$|code-block|syntax|javascript|3133322|编辑:在结束和开始的时候忘记了.*。|offset|length|style|CODE|3133323|entityMap^0|0|0|F|2|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

My solution is leads to a long expression becuase i will permutate over all 6 possibilities the found capital letter, small letter and the needed number can be arranged in the string:

<pre><code>^(.*[a-z].*[A-Z].*[0-9].*|
 .*[a-z].*[0-9].*[A-Z].*|
 .*[A-Z].*[a-z].*[0-9].*|
 .*[A-Z].*[0-9].*[a-z].*|
 .*[0-9].*[a-z].*[A-Z].*|
 .*[0-9].*[A-Z].*[a-z].*)$
</code></pre>

Edit: Forgot the <code>.*</code> at the end and at the beginning.

blocks|key|4016384|text|不幸的是，MySQL不支持查找周围断言，因此您必须为regex引擎拼写它(假设只有这些字符是合法的)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4016385|%5E(
[A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*%7C
[A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*%7C
[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*%7C
[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*%7C
[A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*%7C
[A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*
)$|code-block|syntax|javascript|4016386|或者，在MySQL中：|4016387|SELECT+*+FROM+mytable+WHERE+mycolumn+REGEXP+BINARY+"%5E([A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*%7C[A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*%7C[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*%7C[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*%7C[A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*%7C[A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*)$";|4016388|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Unfortunately, MySQL does not support lookaround assertions, therefore you'll have to spell it out for the regex engine (assuming that only those characters are legal):

<pre><code>^(
[A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*|
[A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*|
[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*|
[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*|
[A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*|
[A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*
)$
</code></pre>

or, in MySQL:

<pre><code>SELECT * FROM mytable WHERE mycolumn REGEXP BINARY "^([A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*|[A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*|[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*[0-9][A-Za-z0-9]*|[A-Za-z0-9]*[A-Z][A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*|[A-Za-z0-9]*[0-9][A-Za-z0-9]*[a-z][A-Za-z0-9]*[A-Z][A-Za-z0-9]*|[A-Za-z0-9]*[0-9][A-Za-z0-9]*[A-Z][A-Za-z0-9]*[a-z][A-Za-z0-9]*)$";
</code></pre>

blocks|key|4016457|text|a-zA-Z0-9*a-z%2Ba-zA-Z0-9*A-Z%2Ba-zA-Z0-9*0-9%2Ba-zA-Z0-9*%7Ca-zA-Z0-9*a-z%2Ba-zA-Z0-9*0-9%2Ba-zA-Z0-9*A-Z%2Ba-zA-Z0-9*%7Ca-zA-Z0-9*A-Z%2Ba-zA-Z0-9*a-z%2Ba-zA-Z0-9*0-9%2Ba-zA-Z0-9*%7Ca-zA-Z0-9*A-Z%2Ba-zA-Z0-9*0-9%2Ba-zA-Z0-9*a-z%2Ba-zA-Z0-9*%7Ca-zA-Z0-9*0-9%2Ba-zA-Z0-9*A-Z%2Ba-zA-Z0-9*a-z%2Ba-zA-Z0-9*%7Ca-zA-Z0-9*0-9%2Ba-zA-Z0-9*a-z%2Ba-zA-Z0-9*A-Z%2Ba-zA-Z0-9*|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4016458|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*|[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*|[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*|[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*|[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*|[a-zA-Z0-9]*[0-9]+[a-zA-Z0-9]*[a-z]+[a-zA-Z0-9]*[A-Z]+[a-zA-Z0-9]*

I'm using a stored procedure to validate the input parameter. The input parameter must contain a-z and A-Z and 0-9. 
for Example: 
<code>aS78fhE0</code> -> Correct 
<code>76AfbRZt</code> -> Correct 
<code>76afbrzt</code> -> Incorrect(doesn't contain Upper Case A-Z) 
<code>asAfbRZt</code> -> Incorrect(doesn't contain Numeric 0-9) 
<code>4QA53RZJ</code> -> Incorrect(doesn't contain Lower Case a-z) 
 
what Regular Expression that can validate the input parameter like above example,.? 
Many Thanks, Praditha
 
UPDATE Others character except Alphanumeric are not allowed I'm Using MySQL version 5

Regex : string must contain a-z and A-Z and 0-9

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我使用一个存储过程来验证输入参数。输入参数必须包含and、and和0-9.例如：aS78fhE0 ->正确76AfbRZt ->正确76afbrzt ->不正确(不包含大写A-Z)asAfbRZt ->不正确(不包含数字0-9)4QA53RZJ ->不正确(不包含小写a)哪个正则表达式可以像上面的例子那样验证输入参数，？非常感谢，普拉迪萨更新除字母数字外，其他字符不允许使用。我使用的是MySQL版

问Regex :字符串必须包含and、and和0-9
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Regex :字符串必须包含and、and和0-9EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Regex :字符串必须包含and、and和0-9
EN