sql 语句:
MySQL 语句:select t.id_value from sys_core_tag t where t.table_name=‘sys_vehicle’ and MATCH(t.who_can
_see_me) AGAINST(’((K0000000500001F48*))’ in boolean mode) 执行没问题
ob:select t.id_value,t.who_can_see_me from sys_core_tag t where t.table_name=‘sys_vehicle’ and MATCH(t.who_can_see_me) AGAINST(’+K0000000500001F48’ in boolean mode)
这种没问题,但是K0000000500001F48这个值换成K0000000500001F48* 就报错,不能把*换成% ,这样结果不符合
这个带通配符* 怎么改写
