Client library version: 5.1.56
MySQLi - хранимая процедура - поиск по полнотекстовому индексу в имени и описании
CREATE PROCEDURE procedure_fulltext_index (IN grp_substring VARCHAR(50))
BEGIN
DROP TEMPORARY TABLE IF EXISTS courses1;
CREATE TEMPORARY TABLE IF NOT EXISTS courses1 ENGINE=MyISAM SELECT* FROM grp;
CREATE FULLTEXT INDEX ixFullText ON courses1(Name,Description);
SELECT idgrp,Name,Description FROM courses1 WHERE MATCH (Name,Description) AGAINST (grp_substring IN BOOLEAN MODE);
END;
not mysqli_real_query
MySQLi - выборка из базы