SQL喜欢和喜欢 [英] SQL Like and like

问题描述

是否可以在一个查询中将多个SQL LIKE通配符串在一起-这样?

Is it possible to string together multiple SQL LIKE wildcards in one query - something like this?

LIKE '% aaaa %' AND LIKE '% bbbb %'

目的是查找包含通配符但没有特定顺序的记录.

The aim is to find records that contain both wild cards but in no specific order.

推荐答案

正确的SQL语法是:

field LIKE '% aaaa %' AND field LIKE '% bbbb %'

这篇关于SQL喜欢和喜欢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！