Blogger Information
Blog 33
fans 0
comment 1
visits 43113
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
MySQL in, find_in_set(条件, 字段),like
萝卜温的博客
Original
1670 people have browsed it

In 表示条件包含字段:

select * from student where id in (1,2,3,4,5,6,8.....)

find_in_set 表示字段包含条件:

select * from article where find_in_set('PHP', tags);//查找标签为PHP的文章

like 表示字段匹配某个模式:

select * from article where title like '%PHP%'; //查找标题中包含PHP关键字的文章


Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post