59 Posts
SemaphoreOxalis
7 months ago
0
Topic

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

Get a VIP membership