Environment MySQL version 5.7.43-log DB variables collation_connection utf8mb4_general_ci collation_database utf8_general_ci collation_server utf8_general_ci table column property CUSTOMER_NM utf8_bin Also, CUSTOMER_NM has a FULLTEXT index on it. The problem SQL: For example, suppose a customer is named PINE APPLE PIZZA. Full capitals, a blank space between each names. SELECT * FROM customer_name_detail cnd WHERE 1=1 AND MATCH(cnd.customer_nm) […]