Hello,
I know how to search ocurrences of a search term within a field values using LIKE.
If you searched for "Apple" this would return "Pineapple"
Please Login or Register to view this content.
But I am trying to do the reverse, so searching "Pineapple" would return "Apple" because apple is within pineapple.
Is there any syntax to do this or do I have to retrieve the whole table and loop through it?
Bookmarks