Consult, don't think the query in a string of Numbers to add the record at the end of a string,-CodePudding

Home > database > Consult, don't think the query in a string of Numbers to add the record at the end of a string,

Consult, don't think the query in a string of Numbers to add the record at the end of a string,

Time：09-20

Want to query not to "11111 _sh" like this at the end of the record how to write

CodePudding user response:

The

refer to the original poster weixin_43391181 response:

want to query not to "11111 _sh" that at the end of the record how to write that

Select * from table name where the field name not like '% 11111 _sh' that should be ok

CodePudding user response:

This would be to use regular expressions, first you have to tell me all of the format are digital _sh? Or the length of the length of the _ character