php - SQL Like and like

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

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.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Answer

深蓝 · Answer 1 · 2021-10-23T18:23:23+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

The correct SQL syntax is:

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

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…