4.2.17. MySQL LIKE clause

发布时间 ： 2025-10-25 13:32:52 UTC      

Page Views: 39 views

We know that we use the SQL SELECT command in MySQL to read data, and we can read data in the SELECT Statement to get the specified record using the WHERE clause.

You can use the equal sign = in the WHERE clause to set conditions for getting data, such as “runoob_author = ‘RUNOOB.COM’”.

But sometimes we need to get runoob_author Field contains all records with the character “COM”, at this point we need to set the WHERE Use the SQL LIKE clause in the clause.

The percent sign% character is used in the SQL LIKE clause to represent any character, similar to the asterisk* in UNIX or regular expressions.

If the% sign is not used, the LIKE clause has the same effect as the equal sign =.

Grammar

The following is the general syntax for SQL SELECT statements to read data from a data table using the LIKE clause:

SELECT field1, field2,...fieldN
FROM table_name
WHERE field1 LIKE condition1 [AND [OR]] filed2 = 'somevalue'

  • You can specify any condition in the WHERE clause.

  • You can use the like clause in the WHERE clause.

  • You can use the LIKE clause instead of the equal sign =.

  • LIKE is usually used with%, similar to a metacharacter search.

  • You can specify one or more conditions using AND or OR.

  • You can use the WHERE…LIKE clause in the DELETE or UPDATE command to specify the condition.

Use the LIKE clause at the command prompt

Next we will use the WHERE…LIKE clause in the SQL SELECT command to read data from the MySQL data table runoob_tbl.

Example

The following is what we will do runoob_tbl Get from the table runoob_author All records that end with COM in the field:

SQL LIKE statement:

mysql>useRUNOOB;Databasechangedmysql>SELECT\*fromrunoob_tblWHERErunoob_authorLIKE'%COM';
+-----------+---------------+---------------+-----------------+
\|runoob_id\|runoob_title\|runoob_author\|submission_date\|
+-----------+---------------+---------------+-----------------+ \|3\|
学习Java\|RUNOOB.COM\|2015-05-01\| \|4\|
学习Python\|RUNOOB.COM\|2016-03-06\|
+-----------+---------------+---------------+-----------------+2rowsinset(0.01sec)

Using the LIKE clause in PHP scripts

You can use the PHP function mysqli_query() And the same SQL SELECT with the command of the WHERE…LIKE clause to get the data.

This function is used to execute the SQL Command, and then pass the PHP Function mysqli_fetch_array() To output data for all queries.

But if it is, DELETE Or UPDATE You do not need to use the S QL statement that uses the WHERE…LIKE clause in the mysqli_fetch_array() Function.

Example

The following is how we use the PHP script in the runoob_tbl Read from the table runoob_author All records that end with COM in the field:

MySQL LIKE clause test:

菜鸟教程
mysqli_fetch_array 测试
';echo'';while($row=mysqli_fetch_array($retval,MYSQLI_ASSOC)){echo"".""."".""."";}echo'
教程
ID标题作者提交日期
{$row['runoob_id']}{$row['runoob_title']}{$row['runoob_author']}{$row['submission_date']}
';mysqli_close($conn);?>

The output is shown in the following figure:

Image0

文章链接 ： 4.2.17. MySQL LIKE clause

Principles and Applications of WebGIS

 37

Web框架

 942

WEB基础

 287

Principles, Technologies, and Methods of Geographic Information Systems

 102

In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress.