Momwe mungafufuzire ngati MySQL?Kagwiritsidwe ka mawu ofanana mu database ya MySQL

Kodi mungatani kuti mufufuze LIKE mu MySQL ? Kodi malamulo ogwiritsira ntchito mawu a LIKE mu ma database a MySQL ndi ati?

MySQL LIKE clause

Timadziwa kugwiritsa ntchito lamulo la SQL SELECT kuti tiwerenge deta mu MySQL, ndipo tikhoza kugwiritsa ntchito ndime ya WHERE mu SELECT statement kuti tipeze zolemba zomwe tafotokozazi.

Gawo la WHERE lingagwiritse ntchito chizindikiro cha equals (=) kukhazikitsa zofunikira zopezera deta, monga "chenweiliang_author = 'chenweiliang.com'".

Koma nthawi zina timafunika kupeza zolemba zonse zomwe gawo la chenweiliang_author lili ndi zilembo za "COM", ndiye tiyenera kugwiritsa ntchito ndime ya SQL LIKE mu ndime ya WHERE.

Chiganizo cha SQL LIKE chimagwiritsa ntchito chizindikiro cha peresenti % kuyimira chizindikiro chilichonse, chofanana ndi nyenyezi * mu UNIX kapena mawu wamba.

Ngati chizindikiro cha peresenti % sichinagwiritsidwe ntchito , gawo la LIKE limakhala ndi zotsatira zofanana ndi chizindikiro chofanana = .

galamala

Zotsatirazi ndizomwe zimagwirizana ndi mawu a SQL SELECT kuti muwerenge deta kuchokera pa tebulo la deta pogwiritsa ntchito ndime ya LIKE:

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

• Mutha kufotokoza chilichonse mu ndime ya KUTI.
• Mutha kugwiritsa ntchito ndime ya LIKE mu ndime ya KUTI.
• Mutha kugwiritsa ntchito ndime ya LIKE m'malo mwa chikwangwani chofanana =.
• LIKE nthawi zambiri imalumikizidwa ndi % Zogwiritsidwa ntchito limodzi, zofanana ndi kufufuza kwa metacharacter.
• Mutha kutchula chimodzi kapena zingapo pogwiritsa ntchito NDI kapena OR.
• Mutha kugwiritsa ntchito KUTI...KUMENE MUNGACHITE mawu oti DELETE kapena UPDATE kuti mutchule zofunikira.

Kugwiritsa ntchito mawu a LIKE mu Command Prompt

Pansipa tidzagwiritsa ntchito KUTI ... MONGA chiganizo mu lamulo la SQL SELECT kuti tiwerenge deta kuchokera pa tebulo la data la MySQL chenweiliang_tbl.

Chitsanzo

Mndandanda wa zolemba zonse kuchokera pa tebulo la chenweiliang_tbl womwe umatha ndi "COM" mu gawo la chenweiliang_author :

mysql> use chenweiliang;
Database changed
mysql> SELECT * from chenweiliang_tbl WHERE chenweiliang_author LIKE '%COM';
+-----------+---------------+---------------+-----------------+
| chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date |
+-----------+---------------+---------------+-----------------+
| 3 | 学习 Java | chenweiliang.com | 2015-05-01 |
| 4 | 学习 Python | chenweiliang.com | 2016-03-06 |
+-----------+---------------+---------------+-----------------+
2 rows in set (0.01 sec)

Kugwiritsa ntchito LIKE clause mu PHP script

Mukhoza kugwiritsa ntchito PHP ntchito mysqli_query() ndi lamulo lomwelo la SQL SELECT ndi KUTI ... LIKE ndime kuti mupeze deta.

Ntchitoyi imagwiritsidwa ntchito pochita malamulo a SQL ndikutulutsa deta pamafunso onse kudzera mu PHP ntchito mysqli_fetch_assoc().

Koma ngati ndi mawu a SQL pogwiritsa ntchito KUTI ... MONGA chiganizo mu DELETE kapena UPDATE, palibe chifukwa chogwiritsira ntchito mysqli_fetch_array() ntchito.

Chitsanzo

Umu ndi momwe timagwiritsira ntchito script ya PHP kuti tiwerenge zolemba zonse zomwe zimathera mu COM mu gawo la chenweiliang_author pa tebulo la chenweiliang_tbl:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT chenweiliang_id, chenweiliang_title, 
 chenweiliang_author, submission_date
 FROM chenweiliang_tbl
 WHERE chenweiliang_author LIKE "%COM"';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 mysqli_fetch_array 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{
 echo "<tr><td> {$row['chenweiliang_id']}</td> ".
 "<td>{$row['chenweiliang_title']} </td> ".
 "<td>{$row['chenweiliang_author']} </td> ".
 "<td>{$row['submission_date']} </td> ".
 "</tr>";
}
echo '</table>';
mysqli_close($conn);
?>