DB design log (7)

最新推荐文章于 2024-09-14 18:42:05 发布

felixleezc

最新推荐文章于 2024-09-14 18:42:05 发布

阅读量464

点赞数

文章标签： search table sql

本文链接：https://blog.csdn.net/felixleezc/article/details/2449654

版权

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.