We use generic search on different fields. We have set "each word exact"
We have make some test and get some weird resultats :
- fonciere : 115
- fonciere : 80
- foncière : 156
- fonciëre : 80
We have display the search and get this :
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS
parent,t0.author_id AS author,t0.author_session AS author_session,t0.cck
AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS
type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_store_form_ressources` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_store_form_article__dossier_thematique` AS t3 ON t3.id = t0.pk
LEFT JOIN `#__cck_store_form_recoltes` AS t4 ON t4.id = t0.pk
LEFT JOIN `#__cck_store_item_content` AS t5 ON t5.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,5)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2024-04-03 14:58' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2024-04-03 14:58' )
AND t0.cck IN ('article__dossier_thematique','recoltes','ressources')
AND
(((t1.title LIKE '%foncière%')) OR ((t1.introtext REGEXP
"(::fulltext::)*.foncière.*(::/fulltext::)")) OR ((t1.introtext REGEXP
"(::introtext::)*.foncière.*(::/introtext::)")) OR ((t1.title LIKE
'%foncière%')) OR ((t2.re_ressources_auteur LIKE '%foncière%')) OR
((t2.re_ressources_contact LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart10 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart2 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart3 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart4 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart5 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart6 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart7 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart8 LIKE '%foncière%')) OR
((t3.dt_dossiers_textespart9 LIKE '%foncière%')) OR
((t4.r_recoltes_soustitre LIKE '%foncière%')) OR ((t5.u_util_editeurs
LIKE '%foncière%')))
ORDER BY t1.created DESC
LIMIT 24
Any explanation ?
Of course we want the same resuts for each accent variant.
Thanks