Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the symbol of all columns in sql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what is the symbol for all columns in sql"?

The symbol in sql that represents all columns is% of the wildcard characters. Wildcards can be used to replace any other character in the string to search for data in the table. Used with the LIKE operator in SQL.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Wildcards can be used to replace any other character in the string.

SQL wildcard

In SQL, wildcards are used with the SQL LIKE operator.

SQL wildcards are used to search for data in a table.

In SQL, the following wildcards can be used:

Example:

Mysql > SELECT * FROM Websites +-- + | id | name | url | alexa | country | +-+-- -+ | 1 | Google | https://www.google.cm/ | 1 | USA | | 2 | Taobao | https://www.taobao.com/ | 13 | CN | | 3 | Rookie tutorial | http://www.runoob.com/ | 5000 | USA | | 4 | Weibo | http://weibo.com/ | 20 | CN | | 5 | Facebook | https://www.facebook.com/ | 3 | USA | | 7 | stackoverflow | http://stackoverflow.com/ | 0 | IND | +-+-- -+

Use SQL% wildcards

The following SQL statement selects all sites where url begins with the letter "https":

SELECT * FROM WebsitesWHERE url LIKE 'https%'

Execute the output result:

At this point, I believe you have a deeper understanding of "what is the symbol of all columns in sql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.