[Date Prev][Date Next] [Chronological] [Thread] [Top]

back-sql modified queries



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