Please help me understand the functionality of the wildcard character with Fulltext searching IN BOOLEAN MODE. For the following searches, I get tangible query results as expected, except for the last search which returns no records from the query. Why is this? 1. +jones +mag* 2. +smith +book* 3. +(+jones +mag*) +(+jones +mag*) 4. (+jones +mag) (+smith +book) 5. (+jones +mag*) (+smith +book*)
Your timely reply would be greatly appreciated, as this is the final piece of code before I release my interface for testing by others. Thank you, Harry Hege