CREATE TABLE `studenti` (
  `uzivatele_id` int,
  `jmeno` varchar(60),
  `prijmeni` varchar(60),
  `pohlavi` varchar(1),
  `PLAT` int,
  `datum_narozeni` date,
  `mesto` varchar(20),
  `fakulta` int,
FULLTEXT KEY jmeno (jmeno)
);

insert into studenti values ('1', 'oo jana oo', 'krátka', 'f', '23500', '1954-12-22', 'Brno', '0');
insert into studenti values ('2', 'Sophia Jana', 'Nováková', 'F', '42261', '2016-11-11', 'Brno', '1');
insert into studenti values ('3', 'afads JANA Sophia', 'Santiago', 'F', '20758', '1962-11-16', 'Brno', '8');
insert into studenti values ('4', 'Jarek na Ford', 'Benes', 'M', '52483', '2017-01-11', 'Praha', '8');
insert into studenti values ('5', 'JANA JANA', 'Malý', 'M', '10000', '2001-09-23', 'Praha', '8');
insert into studenti values ('6', 'JANA jana', 'Adamec', 'M', '29990', '1977-07-27', 'Praha', '7');
insert into studenti values ('7', 'ja na ', 'Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '6');
insert into studenti values ('8', 'Hana', 'Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '7');
insert into studenti values ('9', 'Ivana ha', 'Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '3');





SELECT jmeno FROM studenti WHERE Match(jmeno) Against('jana');

SELECT jmeno FROM studenti WHERE Match(jmeno) Against('+jana -Sophia' IN BOOLEAN MODE);