English 中文(简体)
MySQL SELECT查询字符串匹配
原标题:MySQL SELECT query string matching

通常,当使用SELECT查询数据库时,通常需要查找与给定搜索字符串匹配的记录。

例如:

SELECT * FROM customers WHERE name LIKE  %Bob Smith% ;

该查询应该为我提供Bob Smith出现在名称字段中任何位置的所有记录。

我想做的恰恰相反。

我不想在Robert Bob Smith III博士的姓名字段中找到所有Bob Smith所在的记录,查询的字符串参数。

最佳回答

只要把LIKE转过来

SELECT * FROM customers
WHERE  Robert Bob Smith III, PhD.  LIKE CONCAT( % ,name, % )
问题回答

可以使用这样的正则表达式:

SELECT * FROM pet WHERE name REGEXP  Bob|Smith ; 




相关问题
Simple JAVA: Password Verifier problem

I have a simple problem that says: A password for xyz corporation is supposed to be 6 characters long and made up of a combination of letters and digits. Write a program fragment to read in a string ...

Case insensitive comparison of strings in shell script

The == operator is used to compare two strings in shell script. However, I want to compare two strings ignoring case, how can it be done? Is there any standard command for this?

Trying to split by two delimiters and it doesn t work - C

I wrote below code to readin line by line from stdin ex. city=Boston;city=New York;city=Chicago and then split each line by ; delimiter and print each record. Then in yet another loop I try to ...

String initialization with pair of iterators

I m trying to initialize string with iterators and something like this works: ifstream fin("tmp.txt"); istream_iterator<char> in_i(fin), eos; //here eos is 1 over the end string s(in_i, ...

break a string in parts

I have a string "pc1|pc2|pc3|" I want to get each word on different line like: pc1 pc2 pc3 I need to do this in C#... any suggestions??

Quick padding of a string in Delphi

I was trying to speed up a certain routine in an application, and my profiler, AQTime, identified one method in particular as a bottleneck. The method has been with us for years, and is part of a "...

热门标签