比如,我在一个表中要查找以王开头的名字。select name from prio where name like '王%' 还是
select name from prio where name like '“王”%'
select name from prio where name like '王%',不是用双引号,我还以为是
select name from prio where name like ' '王' %' 很久都没有用了,sql也从电脑上卸载了,突然想到些细节,就想弄清楚。
不用把王括起来,就用select name from prio where name like '王%'
%是通配任意多个字符