indexing - What is the best way to create or modify an index for fast searching in MySQL for unstructured information? -
i working on project have query data different devices (example data attached below). querying data using
select * `table` `data` '%5.3%'
this took long time every query created fulltext index on data. wrote following query find same product version, not same information query gets.
select `data` `table` match(`data`)against('+"5.3"' in boolean mode);
i wondering fastest way search type of data is. should modify index created or there method this. have attached sample data try find version number 5.3 below. time
ssh-2.0-openssh_5.3p1 debian-5ubuntu1.3 key type: ssh-rsa key: aaawtywtyhwhtgwji40rvs84ylx5a19psfdgr45ywrwsrh6msvlswertwthgwmt knbqsuozljiccdl/m/m/dyc+ivekkesrkspaprlf46xem tfozhfqks7mys1zu4ed/eb2hvpauvqgsadfk9refr0qo985n+xjuqv55wze8loz4lqv+/g/5 fingerprint: 00:00:00:00:00:00:00