MYSQL

MYSQL SEARCH (EXACT LIKE FUZZY)

PLAIN SEARCH SELECT * FROM `TABLE` WHERE `FIELD` = "SEARCH"

EXACT MATCH SEARCH

01

CASE SENSITIVE SEARCH SELECT * FROM `TABLE` WHERE `FIELD` = BINARY "SEARCH"

FIELD MUST CONTAIN “SEARCH”. SELECT * FROM `TABLE` WHERE `FIELD` LIKE '%SEARCH%'

SEARCH MUST CONTAIN

02

FIELD MUST START WITH “SEARCH”. SELECT * FROM `TABLE` WHERE `FIELD` LIKE 'SEARCH%'

FIELD MUST END WITH “SEARCH”. SELECT * FROM `TABLE` WHERE `FIELD` LIKE '%SEARCH';

SELECT * FROM `TABLE` WHERE MATCH(`COLUMN`) AGAINST ('SEARCH' IN NATURAL LANGUAGE MODE);

FUZZY SEARCH

03