|
I've successfully set up back-sql so that my
thunderbird email users can query the email addresses from our
MySql CRM database. This works well. I noticed (by running slapd
in debug mode) that the database query looks like this: Constructed query: SELECT DISTINCT ldap_entries.id,ldap_persons.id,'inetOrgPerson' AS objectClass, ldap_entries.dn AS dn FROM ldap_entries,ldap_persons WHERE ldap_persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND ldap_entries.parent=? AND ((fullname LIKE 'piet%') OR (email LIKE 'piet%') OR (last LIKE 'piet%')) I would like the query to find the search string inside the fields as well as at the start of the fields, so I would like to add more wildcards to the search like this: AND ((fullname LIKE '%piet%') OR (email LIKE '%piet%') OR (last LIKE '%piet%')) Is there a way for me to make this change? Thanks, Mark |