谁说的????like '?1%'
------------------------------------------------------
我们还年轻牛奶会有的奶牛也会有的
可天天在 csdn 混这些会有吗 ??
------------------------------------------------------
我们还年轻牛奶会有的奶牛也会有的
可天天在 csdn 混这些会有吗 ??
解决方案 »
- SSH框架测试时报错啊,谁来给我看看啊,谢谢啦
- 如何用JAVA以及dom4j解决XML中重复数据合并的问题
- 请教一个在jsp中等待的问题。哪位知道给指点一下
- eclipse 远程调试能不能在本地打印控制台的信息
- jboss启动失败,javax.management.InstanceNotFoundException
- MyEclipse中建立数据源后无法连接,提示字符集错误,该怎么办?
- Request timed out waiting for an available thread to run是什么回事,是由什么引起的?
- java编程思想的一个小问题
- 求助,cannot create poolableconnectionfactory错误,各位帮帮忙
- 现在要做一个在线书店,如何实现书的分类
- 关于JAVA继承的问题?(初学者)
- 大家看我这样水平的能在北京找到工作吗?
?1,?2分别是EJB FIND方法的参数
11.2.6.9 Like expressions
The syntax for the use of the comparison operator [NOT] LIKE in a conditional expression is as follows:
cmp_path_expression [NOT] LIKE pattern_value [ESCAPE escape_character]The cmp_path_expressionmust have a string value. The pattern_valueis a string literal or a string-valued
input parameter in which an underscore (_) stands for any single character, a percent (%) character
stands for any sequence of characters (including the empty sequence), and all other characters stand for
themselves. The optional escape_character is a single-character string literal or a character-valued
input parameter (i.e., char or Character) and is used to escape the special meaning of the underscore
and percent characters in pattern_value.[23]
Examples are:
address.phone LIKE ‘12%3’ is true for ‘123’ ‘12993’ and false for ‘1234’
asentence.word LIKE ‘l_se’ is true for ‘lose’ and false for ‘loose’
aword.underscored LIKE ‘\_%’ ESCAPE ‘\’ is true for ‘_foo’ and false for ‘bar’
address.phone NOT LIKE ‘12%3’ is false for ‘123’ and ‘12993’ and true for ‘1234’?
If the value of the cmp_path_expression or pattern_value is NULL or unknown, the value of the LIKE
expression is unknown. If the escape_characteris specified and is NULL, the value of the LIKE expression
is unknown. ------------------------------------------------------
我们还年轻牛奶会有的奶牛也会有的
可天天在 csdn 混这些会有吗 ??