I'm in MySQL right now. To write a query statement to query the name attribute in the Customer table that contains% (percent semicolon) a query that the master told how to write thank you urgently!!!
For example: SELECT * from customer where name like ' King% ';
MySQL like statement wildcard
MySQL provides standard SQL pattern matching and a format for extending regular expression pattern matching based on Unix utilities like VI, grep, and sed.
_ represents one character, and% is 0 to any character
If your query statement contains% of this special character, then/% or [%] can
Play the role of an escape character
Like ' 5[%] ' means 5%
Like ' 5% ' means 5 followed by more than 0 more characters
Like ' [_]h ' denotes-n
Like ' _n ' means an,bn,on (and so on)
Like ' [A-CDF] ' means a, B, C, D, or F
Like ' [-ACDF] ' means-, a, C, D, or F
Like ' [[] ' means [
Like '] ' says
Second, the example description:
Look in the table Personalmember to find records in the Strloginname field that contain "[".
You can use three statements:
1,
Select strloginname,* from Personalmember where strloginname like '%[% ' escape '
2, (description "" and "/" can be combined with the escape keyword as an escape character)
Select strloginname,* from Personalmember where strloginname like '%/[% ' escape '/'
3,
Select strloginname,* from dbo. Personalmember where CHARINDEX (' [', Strloginname) >0
---------------------------
Microsoft Internet Explorer--------------------------