Sorting by mysql String Match Query

Mysql string matching level query and sorting implement the Class search engine function, implement the matching level query table structure creation syntax CREATETABLE 'others' ('id' int (11) NOTNULLCOMMENTid, 'namess 'varchar (200) DEFAULTNULLCOMMENT username, PRIMARYKEY ('id') enginemyisamdefacharcharset

Mysql string matching degree query and sorting implement the Class search engine function, implement the matching degree query TABLE structure creation syntax create table 'People' ('id' int (11) not null comment 'id ', 'namess' varchar (200) default null comment 'username', primary key ('id') ENGINE = MyISAM DEFAULT CHARSET

Sorting of mysql String Matching

Implement functions similar to search engines to achieve matching Query

Table Structure creation syntax

Create table 'People' ('id' int (11) not null comment 'id', 'namess 'varchar (200) default null comment 'username ', primary key ('id') ENGINE = MyISAM default charset = utf8

General query statement

SELECT * FROM 'people' WHERE namess LIKE '% sheets % ';

Query SQL statements by matching degree

SELECT * FROM 'people' WHERE namess LIKE '% sheets % 'order by replace (namess, 'zhang ','')