access中有LIKE吗？

2004-12-09 05:21:14 3.6k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

滚动轴承振动信号特征解析与故障诊断模型构建本文深入解析了滚动轴承振动信号的三大来源与特征，并详细阐述了从时域、频域到时频域的特征提取方法。通过构建基于机器学习（如随机森林、SVM）或深度学习的故障诊断模型，结合实战代码示例，为设备维护工程师提供了一套从信号分析到智能诊断的完整解决方案，旨在实现精准的故障识别与预测性维护。阅读详情

想做模糊查询，不知道ACCESS中怎么写SQL语句？

想达到类似这样的目的：select * from table where name like '%a%'
查出所有名称中包含'a'的记录

...全文

图像配准方法之灰度信息法这系列文章是5年前的，也是从自己的QQ（632846506）日志中移过来的。https://user.qzone.qq.com/632846506/infocenter。图像配准的方法主要有三种：基于灰度信息方法；基于空间变换域方法；基于图像特征的方法。一、灰度信息法。灰度信息法直接利用两幅图像之间灰度度量的相似性，以图像内部的信息为依据，采用搜索方法寻找相似度最大或阅读详情

leiming

Access 7,731 成员 28,797 内容

+ 关注 + 加入社区

切换为时间正序

oyljerry 2004-12-11

打赏
举报

access中用*

bluedue 2004-12-11

打赏
举报

access可以用%

赖勇浩 2004-12-11

打赏
举报

SQL Server中用%
Access中用*

这个是正解,帮我解决问题了啊,谢谢你/

chyf212 2004-12-10

打赏
举报

把＊号改成％就可以用啦

alan chen 1315333 qq 2004-12-10

打赏
举报

自己试一试

alan chen 1315333 qq 2004-12-10

打赏
举报

我都用的select * from table where name like '%a%' ，asp里，jet sql，
一直都正常。

liuyann 2004-12-09

打赏
举报

ACCESS中LIKE的用法

Like Operator
Compares a string expression to a pattern in an SQL expression.

Syntax
expression Like “pattern”

The Like operator syntax has these parts:

Part Description
expression SQL expression used in a WHERE clause.
pattern String or character string literal against which expression is compared.

Remarks
You can use the Like operator to find values in a field that match the pattern you specify. For pattern, you can specify the complete value (for example, Like “Smith”), or you can use wildcard characters to find a range of values (for example, Like “Sm*”).

In an expression, you can use the Like operator to compare a field value to a string expression. For example, if you enter Like “C*” in an SQL query, the query returns all field values beginning with the letter C. In a parameter query, you can prompt the user for a pattern to search for.

The following example returns data that begins with the letter P followed by any letter between A and F and three digits:

Like “P[A-F]###”

The following table shows how you can use Like to test expressions for different patterns.

Kind of match
Pattern Match
(returns True) No match
(returns False)
Multiple characters a*a aa, aBa, aBBBa aBC
*ab* abc, AABB, Xab aZb, bac
Special character a

a a*a aaa
Multiple characters ab* abcdefg, abc cab, aab
Single character a?a aaa, a3a, aBa aBBBa
Single digit a#a a0a, a1a, a2a aaa, a10a
Range of characters
[a-z] f, p, j 2, &
Outside a range [!a-z] 9, &, % b, a
Not a digit [!0-9] A, a, &, ~ 0, 1, 9
Combined a[!b-m]# An9, az0, a99 abc, aj0

OracleRoob 2004-12-09

打赏
举报

SQL Server中用%
Access中用*

changechange 2004-12-09

打赏
举报

select * from table where name like '*a*'

access中有LIKE吗？

相关推荐