SQL LIKE通配符空格字符 [英] SQL LIKE wildcard space character

问题描述

假设我有一个字符串，其中单词之间用1个或多个空格分隔，我想在SQL LIKE条件下使用该字符串.如何制作我的SQL并告诉它匹配字符串中的1个或多个空格字符?是否可以使用SQL通配符来做到这一点?

let's say I have a string in which the words are separated by 1 or more spaces and I want to use that string in and SQL LIKE condition. How do I make my SQL and tell it to match 1 or more blank space character in my string? Is there an SQL wildcard that I can use to do that?

让我知道

推荐答案

如果您只想获取至少一个空格/空格的内容，则可以执行以下WHERE myField LIKE '% %'

If you're just looking to get anything with atleast one blank / whitespace then you can do something like the following WHERE myField LIKE '% %'

这篇关于SQL LIKE通配符空格字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！