[Mysql] Full text search on category page
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
[Mysql] Full text search on category page
How could I turn on full text search in catalog?
Now, if I search product via search bar – queries in mysql DB didn't use MATCH (col1,) AGAINST (expr).
And in mysql log I see:
How could I use full text search in project? Any configurations?
---
Laravel, aimeos 2018.04.4, PHP 7.0.22-0ubuntu0.16.04.1
Now, if I search product via search bar – queries in mysql DB didn't use MATCH (col1,) AGAINST (expr).
And in mysql log I see:
Code: Select all
SELECT COUNT(*) AS "count"
FROM (
SELECT DISTINCT mpro."id"
FROM "mshop_product" AS mpro
LEFT JOIN "mshop_index_catalog" AS mindca USE INDEX ("idx_msindca_s_ca_lt_po", "unq_msindca_p_s_cid_lt_po") ON mindca."prodid" = mpro."id"
LEFT JOIN "mshop_index_text" AS mindte ON mindte."prodid" = mpro."id"
WHERE ( mpro."siteid" IN (1) AND ( ( SELECT COUNT(DISTINCT mindte2."prodid")
FROM "mshop_index_text" AS mindte2
WHERE mpro."id" = mindte2."prodid" AND mindte2."siteid" IN (1,1,1) AND mindte2."listtype" IN ('default')
AND ( mindte2."langid" = 'en' OR mindte2."langid" IS NULL ) AND POSITION( 'pen ball' IN mindte2."value" ) > 0 ) > 0 AND ( mindca."catid" IN (1,15,240) AND ( mindca."catid" IS NOT NULL AND ( mpro."status" = 1 AND ( mpro."start" IS NULL OR mpro."start" <= '2018-07-10 17:21:00' ) AND ( mpro."end" IS NULL OR mpro."end" >= '2018-07-10 17:21:00' ) ) ) AND mindca."siteid" IN (1,1,1) AND mindca."catid" IN ( '1','15','240' ) AND mindca."listtype" = 'default' AND mindca."pos" >= 0 ) ) )
LIMIT 1000 OFFSET 0
) AS list
---
Laravel, aimeos 2018.04.4, PHP 7.0.22-0ubuntu0.16.04.1
Re: [Mysql] Full text search on category page
This should be the default case if you haven't overridden that in your ./config/shop.php file:
The MySQL specific text index manager uses fulltext search for efficient lookups.
Code: Select all
'mshop' => array(
'index' => array(
'manager' => array(
'name' => 'MySQL',
'attribute' => array(
'name' => 'MySQL',
),
'catalog' => array(
'name' => 'MySQL',
),
'price' => array(
'name' => 'MySQL',
),
'supplier' => array(
'name' => 'MySQL',
),
'text' => array(
'name' => 'MySQL',
),
),
),
),
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: [Mysql] Full text search on category page
Thanks! It works!