MYSQL
(quick guide & examples)
CASE INSENSITIVE SEARCH SELECT * FROM `TABLE` WHERE `COL` = "SEARCH"
CASE SENSITIVE SEARCH SELECT * FROM `TABLE` WHERE `COL` = BINARY "SEARCH"
MUST CONTAIN “SEARCH” SELECT * FROM `TABLE` WHERE `COL` LIKE "%SEARCH%"
MUST START WITH “SEARCH” SELECT * FROM `TABLE` WHERE `COL` LIKE "SEARCH%"
MUST END WITH “SEARCH” SELECT * FROM `TABLE` WHERE `COL` LIKE "%SEARCH"
EVERYTHING THAT IS "CLOSE ENOUGH" TO "SEARCH" SELECT * FROM `TABLE` WHERE MATCH(`COLUMN`) AGAINST ("SEARCH" IN NATURAL LANGUAGE MODE);
EITHER A *OR* B MUST CONTAIN "SEARCH" SELECT * FROM `TABLE` WHERE `A` LIKE "%SEARCH%" OR `B` LIKE "%SEARCH%"
BOTH A *AND* B MUST CONTAIN "SEARCH" SELECT * FROM `TABLE` WHERE `A` LIKE "%SEARCH%" AND `B` LIKE "%SEARCH%"