MYSQL 怎么模糊搜索啊。咋我实现不了的
CAS登录号:00000-66-9
中文名称:闪图世界
中文别名:新闪图世界,闪图世界就是硬
英文名称:asdaASD3
英文别名:asdRTRTRT
EINECS登录号:asdasdFGFG
MDL登录号:sadaUG
SMILES:sdasRTR
注意蓝色部分为:全文搜索字段
------------------------------------------------------------
上面为一条记录的例子,关键字为英文文别名中的几个英文:
我试过的SQL语句,我要实现任何一个字段包含这个关键字都返回:
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('+dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('*dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('dRTRT*' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('*dRTRT*' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
----------------------------------
咋办啊。新手求指教···
中文名称:闪图世界
中文别名:新闪图世界,闪图世界就是硬
英文名称:asdaASD3
英文别名:asdRTRTRT
EINECS登录号:asdasdFGFG
MDL登录号:sadaUG
SMILES:sdasRTR
注意蓝色部分为:全文搜索字段
------------------------------------------------------------
上面为一条记录的例子,关键字为英文文别名中的几个英文:
我试过的SQL语句,我要实现任何一个字段包含这个关键字都返回:
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('+dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('*dRTRT' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('dRTRT*' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
select count(sid) from jtbc_supply where 1 and MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('*dRTRT*' IN BOOLEAN MODE) and s_hidden = 0 【失败,没记录】
----------------------------------
咋办啊。新手求指教···
作者: ldxsik 发布时间: 2011-05-21
紧急啊。有人能帮忙不
作者: ldxsik 发布时间: 2011-05-21