Question

sql语句中的like语句中%和*的区别

Answer 1

*是一个实际的字符,而%是通配符,两个不是一个概念
sql中的通配符%才代表任意字符，*在sql中没有通配符的意思，虽然在像DOS环境之类下是代表任意字符的意思
elect * from sysuser a where a.login_name like 'sys*';
等于
select * from sysuser a where a.login_name = 'sys*';

Answer 2

多增加一些like条件即可，并用括号括起来 select * from [!db.pre!]ecms_news where checked=1 and ( keyboard like '%美容%' or keyboard like '%护肤%' or keyboard like '%祛痘%' or keyboard like '%美白%' ) order by newstime

Answer 3

like用在where，表色省略许多字符。
where name like “张%”；

*用在 from
select *
from table