[Visual basic]搜索可能性词 [英] [Visual basic] Search possibility word

问题描述

大家好，



是否有任何论坛讨论或完成如何使用字符串中的某些单词查找数据的教程？意味着可能性或接近正确的词。就像我有一个数据电话Calvin Klein。当他们键入Cal并按Enter键时，它将查看选择结果，其结果是Calvin Klein，Calibre和Calorie数据库中存在哪些数据。不是来自互联网。仅搜索数据库数据范围的可能性。如果数据只有一个有Cal字的数据，它将显示所有信息。



我需要这个想法

解决方案

您可以随时执行以下操作：

从表中选择*，其中searchCol类似于'UserInput％'

Hi all,

Is there any forum that discuss or complete tutorial on how to find a data by using some of word from a string? Meaning the possibility or near the correct word. Like I have a data call Calvin Klein. When they type Cal and press enter, it will view the "Select result" where result have Calvin Klein, Caliber and Calorie which data that exist in database. Not from the internet. Searching possibility on range of database data only. If the data is only one that have Cal word, it will display all information on it.

I need the idea from this

解决方案

You could always do something like:

select * from table where searchCol like 'UserInput%'

这篇关于[Visual basic]搜索可能性词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！