What can be written in SQL instead of Like statements?

This article introduces the relevant knowledge of "what can be written in SQL instead of Like sentences". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

For example, to find all users whose user name contains "c", you can use the

Use mydatabase

Select * from table1 where username like'%c% "

Here is another way to accomplish the above functions:

Use mydatabase

Select * from table1 where charindex ('cantilever username) > 0

This method theoretically has one more judgment sentence than the previous method, that is, > 0, but this judgment process is the fastest. I think more than 80% of the operations are spent on finding words.

Strings and other operations, so using the charindex function is not a big deal. There are also advantages to using this method, that is, for%, | you can't use like directly.

The characters found can be directly used in this charindex, as follows:

Use mydatabase

Select * from table1 where charindex ('%', username) > 0

It can also be written as:

Use mydatabase

Select * from table1 where charindex (char (37), username) > 0

The character of ASCII is%

This is the end of the content of "what can be written in SQL instead of Like sentence". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!