DB design log (7)

最新推荐文章于 2025-12-01 21:16:51 发布

原创最新推荐文章于 2025-12-01 21:16:51 发布 · 506 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#search #table #sql

本文介绍了一种使用 SQL 语句进行模糊搜索的方法。作者最初尝试通过条件判断语句结合计数器来构造 SQL 语句，但无法实现条件作为结果的一部分进行模糊查询。经过团队成员的建议，最终采用 LIKE 和 % 符号实现了有效的模糊查询。

May 13

Accompanied with yesterday's unfinished work, I stared a new day.

The most important part of today's difficult is the ambiguous searching. I am by no means adversant in the db manipulating language, so finding a suitable way for composed condition searching is a little intricated. At first I used the condition judging statement mixed with a counter to conceived a sql statement like this, "select table where member name=XXX.....". Nevertheless, Such statement could not successfully finish a vague quary that the condition is a sequencial part of the result.

Then, after some communication with another coder of our team, he gave me a perfect solution, the using of "like" and "%".

After further adusting and some change, the search works.