Nzira yekubvunza sei MySQL se?Mashandisirwo emashoko akafanana mudhatabhesi reMySQL

mysql Kubvunza sei?mysql databaseChinese inoda kushandiswa kwechirevo

MySQL LIKE clause

Isu tinoziva kushandisa iyo SQL SELECT command kuverenga data muMySQL, uye isu tinogona kushandisa iyo WHERE clause mu SELECT statement kuti titore marekodhi akatsanangurwa.

Chiratidzo chakaenzana chinogona kushandiswa muchirevo cheWHERE = Kugadzirisa mamiriro ekuwana data, senge "chenweiliang_author = 'chenweiliang.com'".

Asi dzimwe nguva tinoda kuwana ese marekodhi ane chenweiliang_author ndima ine "COM" mavara, tozofanira kushandisa SQL LIKE clause muWHERE clause.

Kushandisa zviratidzo zvezana muSQL LIKE clauses %hunhu hwekumiririra chero hunhu, hwakafanana neasterisk muUNIX kana mataurirwo enguva dzose *.

Kana pasina chiratidzo chezana chinoshandiswa %, KUFANANA nechirevo chine zviratidzo zvakaenzana = Mhedzisiro yacho yakafanana.

girama

Inotevera ndiyo yakajairika syntax yeSQL SELECT chirevo kuverenga data kubva patafura yedata uchishandisa LIKE clause:

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

• Iwe unogona kutsanangura chero mamiriro muWHERE clause.
• Unogona kushandisa LIKE clause muWHERE clause.
• Unogona kushandisa LIKE clause pachinzvimbo chechiratidzo chakaenzana =.
• LIKE inowanzobatanidzwa ne % Inoshandiswa pamwe chete, yakafanana nekutsvaga kwemetacharacter.
• Unogona kutsanangura imwe kana mamwe mamiriro uchishandisa AND kana OR.
• Unogona kushandisa ZVINO...KUFANANA nechikamu muDELETE kana UPDATE mirairo kutsanangura mamiriro.

Kushandisa iyo LIKE Clause mu Command Prompt

Pazasi tichashandisa iyo WHERE...KUFANANA nechikamu muSQL SELECT command kuverenga data kubva paMySQL data table chenweiliang_tbl.

muenzaniso

Izvi zvinotevera matorero atichaita iyo chenweiliang_author ndima mune chenweiliang_tbl tafura ine COM zvemarekodhi ese anopera ne:

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)

Kushandisa LIKE clause mune PHP script

Unogona kushandisa PHP function mysqli_query() uye yakafanana SQL SELECT command ine HERE...KUFANANA nechikamu kuti uwane data.

Iri basa rinoshandiswa kuita SQL mirairo uye wozoburitsa data kune ese mibvunzo kuburikidza neiyo PHP basa mysqli_fetch_assoc().

Asi kana chiri chirevo cheSQL uchishandisa WHERE...KUFANANA nechikamu muDELETE kana UPDATE, hapana chikonzero chekushandisa mysqli_fetch_array() basa.

muenzaniso

Heano mashandisiro atinoita script yePHP kuverenga marekodhi ese anopera muCOM mune chenweiliang_author ndima muchenweiliang_tbl tafura:

<?
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);
?>