Got it

Huawei Enterprise Support Community

Community Forums Intelligent Collaboration

how to query the record that contain some special number

Created: Apr 4, 2016 20:56:43Latest reply: Apr 5, 2016 10:43:34 1401 1 0 0 0

how to query the record that contain some special number, for example you want all the record that callee number contains 7788

x
convention：
Emotion(0)

Like (0) Dislike (0) Favorite(0) Report

 Previous: ESpaceMediaTeller.html Page Does Not Ring After Receiving a Call from the ESpace

Next: Telepresence Host‘s Version Not Match One of the Telepresence Codecs‘ Software V



(0) (0)

^2#

swdut793 Created Apr 5, 2016 10:43:34

we can use "like" and "%" to search the record that contains special number :

select * from tbilllog061 where calleeno like '%7788%';

all the calleeno that contains 7788 will display

x
convention：

Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:

Politically sensitive content
Content concerning pornography, gambling, and drug abuse
Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy

Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.

Please bind your phone number to obtain invitation bonus.

Enterprise

Consumer

Corporate

Carriers

how to query the record that contain some special number

Third Party’s Trade Secret

My Followers