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.
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.
The correct SQL syntax is:
field LIKE '% aaaa %' AND field LIKE '% bbbb %'