What do I write in my LIKE statement so that it matches all strings consisting of two words separated by one space?
我在LIKE语句中写什么,以便它匹配由一个空格分隔的两个单词组成的所有字符串?
2 个解决方案
#1
3
You could try this:
你可以试试这个:
WHERE x LIKE '%_ _%'
AND x NOT LIKE '% % %'
Note that it will be slow! If your table can be large and you need to do this often, you may want to rethink your design.
请注意,它会很慢!如果您的桌子很大并且您需要经常这样做,您可能需要重新考虑您的设计。
#2
0
In general, you can try matching "[zero or more charactersInYourString][space][zero or more charactersInYourString]".
通常,您可以尝试匹配“[零个或多个charactersInYourString] [空格] [零个或多个charactersInYourString]”。
For example
"[a-zA-Z0-9]*[[:space:]][a-zA-Z0-9]*"
for a string that is composed of lower case, upper case letters and numbers seperated by a space.
对于由小写,大写字母和由空格分隔的数字组成的字符串。
#1
3
You could try this:
你可以试试这个:
WHERE x LIKE '%_ _%'
AND x NOT LIKE '% % %'
Note that it will be slow! If your table can be large and you need to do this often, you may want to rethink your design.
请注意,它会很慢!如果您的桌子很大并且您需要经常这样做,您可能需要重新考虑您的设计。
#2
0
In general, you can try matching "[zero or more charactersInYourString][space][zero or more charactersInYourString]".
通常,您可以尝试匹配“[零个或多个charactersInYourString] [空格] [零个或多个charactersInYourString]”。
For example
"[a-zA-Z0-9]*[[:space:]][a-zA-Z0-9]*"
for a string that is composed of lower case, upper case letters and numbers seperated by a space.
对于由小写,大写字母和由空格分隔的数字组成的字符串。