12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
建站问答 时间:2024-12-01 19:05:26
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
instr函数在mysql中的用法语法:INSTR(str,substr)注:str:从哪个字符串中搜索substr:要搜索的子字符串sql语句如下:# 将instr结果作为一列,并按其排序select id,1 from world_guide w
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
instr函数在mysql中的用法
语法:
INSTR(str,substr)
注:
str:从哪个字符串中搜索
substr:要搜索的子字符串
sql语句如下:
# 将instr结果作为一列,并按其排序
select id,1 from world_guide where id = 32
union
select * from
(select id, instr('30,35,31,',id+',') as d from
world_blog where id in (30,35,31) order by d) as t;
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19