Originally Posted by SlayerACC
and DEBUG SQL:
ArrayDEBUG SQL: Resource id #15
Pardon me, but that's impossible if you actually used the code I showed.
In my code $sql is nothing but a string. That looks like you echoed the $result.
And if the OR version worked, the AND version should work, too. But only if you actually had some data that matched the condition! In the $pattern that you showed:
## LIKE '%new%' AND ## LIKE '%old%'
that would mean that one of the tested fields has to contain *BOTH* "new" and "old".
As I said, it depends on what you want.