Sida loo waydiiyo MySQL like? Isticmaalka qoraalka la midka ah ee xogta MySQL

MySQL Sidee loo weydiiyaa sida?mysql databaseShiineesku wuu jecel yahay isticmaalka hadalka

MySQL LIKE faqrad

Waxaan ognahay inaan isticmaalno amarka SQL SELECT si aan ugu akhrino xogta MySQL, waxaanan isticmaali karnaa qodobka SELECT si aan u helno diiwaannada la cayimay.

Calaamadda siman waxa lagu isticmaali karaa qodobka HALKEE = Si loo dejiyo shuruudaha helitaanka xogta, sida "chenweiliang_author = 'chenweiliang.com'".

Laakiin mararka qaarkood waxaan u baahanahay inaan helno dhammaan diiwaanada ay goobta chenweiliang_author ka kooban yahay "COM" jilayaasha, ka dib waxaan u baahanahay inaan isticmaalno SQL LIKE faqrad ku jirta halkee.

Isticmaalka calaamadaha boqolleyda ee SQL LIKE faqradaha %dabeecad si ay u matasho dabeecad kasta, oo la mid ah astaanta UNIX ama tibaaxaha caadiga ah *.

Haddii aan boqolkiiba boqol calaamada la isticmaalin %, LIKE faqrad leh calaamad siman = Saameyntu waa isku mid.

naxwaha

Kuwa soo socdaa waa jumlada guud ee bayaanka SQL SELECT si aad u akhrido xogta shaxda xogta iyadoo la adeegsanayo qodobka LIKE:

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

• Waxaad ku qeexi kartaa xaalad kasta oo ku jirta qodobka HALKEE.
• Waxaad isticmaali kartaa faqradda LIKE ee ku jirta qodobka HALKEE.
• Waxaad isticmaali kartaa qodobka LIKE oo ku jira calaamadda isla'egta =.
• LIKE badanaa waxa lala xidhiidhiyaa % La wada isticmaalo, oo la mid ah raadinta xarfaha meta.
• Waxaad cayimi kartaa hal ama in ka badan oo shuruudo ah addoo isticmaalaya AND ama AMA
• Waxaad isticmaali kartaa HALKE...LIKE faqradda ku jirta DELETE ama UPDATE amarrada si aad u qeexdo shuruudaha.

Isticmaalka faqradda LIKE ee isla markiiba amarka

Hoos waxaan isticmaali doonaa WHERE...LIKE faqradda ku jirta amarka SQL SELECT si aan u akhriyo xogta miiska xogta MySQL chenweiliang_tbl.

tusaale

Midda soo socota waa sida aan ku heli doonno goobta chenweiliang_author ee miiska chenweiliang_tbl oo leh COM dhammaan diiwaanada ku dhamaanaya:

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)

Isticmaalka LIKE clause ee qoraalka PHP

Waxaad isticmaali kartaa PHP function mysqli_query() iyo isla amarka SQL SELECT oo wata WHERE...LIKE clause si aad xogta u hesho.

Shaqadan waxaa loo isticmaalaa in lagu fuliyo amarrada SQL ka dibna soo saaro xogta dhammaan weydiimaha iyada oo loo marayo PHP function mysqli_fetch_assoc().

Laakin haddii ay tahay bayaan SQL ah oo isticmaalaya WHERE...LIKE clause ee DELETE ama UPDATE, looma baahna in la isticmaalo mysqli_fetch_array().

tusaale

Waa kan sida aan u isticmaalno qoraalka PHP si aan u akhrino dhammaan diiwaannada ku dhammaanaya COM ee goobta chenweiliang_author ee miiska 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);
?>