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