SQL Like and like

Question

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.

Answer 1

The correct SQL syntax is:

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