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 【失败,没记录】----------------------------------
咋办啊。新手求指教···
select count(sid) from jtbc_supply where (MATCH (s_ebname,s_einecs,s_mdl,s_smiles) AGAINST ('dRTRT' IN BOOLEAN MODE)) and s_hidden = 0 limit 1
select count(sid) from jtbc_supply where s_ebname like '%字符串%' or s_einecs like '%字符串%' or s_mdl like '%字符串%' or s_smiles like '%字符串%';