[SQL] pobierz, plaintext 
AND MATCH(name) AGAINST('Brosz* +MARIA+ a+' IN BOOLEAN MODE)
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT MATCH(name) AGAINST('kółko' IN BOOLEAN MODE) AS matching, product.id AS id, product.warehouse_id AS warehouse_id, product.customer_id AS customer_id, product.warehouse_category_id AS warehouse_category_id, product.code AS code, product.name AS name, product.product_description AS product_description, product.width AS width, product.height AS height, product.depth AS depth, product.set_description AS set_description, product.curent_quality AS curent_quality, product.is_damaged AS is_damaged, product.damage_quality AS damage_quality, product.damage_description AS damage_description, product.is_deleted AS is_deleted, product.is_for_rent AS is_for_rent, product.rent_price_netto AS rent_price_netto, product.rent_type AS rent_type, product.is_for_3d AS is_for_3d, product.file_3d_extension AS file_3d_extension, product.buying_cost AS buying_cost, product.renovation_cost AS renovation_cost 
FROM products AS product 
WHERE 
is_deleted = '0' 
AND warehouse_id = '12' 
AND MATCH(name) AGAINST('kółko' IN BOOLEAN MODE) 
HAVING matching > 0.200000 
ORDER BY matching DESC, name
[SQL] pobierz, plaintext