MySQL全文搜索

搜索字段

SELECT * FROM `iot`.`equipment` WHERE `iot`.`equipment`.`id` = 8 
OR CAST(`iot`.`equipment`.`mac` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%8%' 
OR `iot`.`equipment`.`home_id` = 8 
OR CAST(`iot`.`equipment`.`create_time` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%8%' 
OR CAST(`iot`.`equipment`.`update_time` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%8%' 
OR `iot`.`equipment`.`able` = 8 
OR `iot`.`equipment`.`type_id` = 8