E fa'afefea ona fesiligia MySQL pei?O le fa'aogaina o fa'amatalaga tutusa ile MySQL database

mysql E fa'afefea ona fesili pei?mysql databaseFa'aaogā fa'amatalaga e pei o Saina

MySQL LIKE fuaiupu

Matou te iloa e faʻaaoga le SQL SELECT poloaiga e faitau faʻamatalaga i MySQL, ma e mafai ona matou faʻaogaina le WHERE fuaiupu i le SELECT faʻamatalaga e maua ai faʻamaumauga faʻamaonia.

Ole fa'ailoga tutusa e mafai ona fa'aoga ile WHERE fuaiupu = Fa'atulaga tulaga mo le mauaina o fa'amaumauga, pei o le "chenweiliang_author = 'chenweiliang.com'".

Ae o nisi taimi tatou te manaʻomia le mauaina o faʻamaumauga uma o loʻo i ai i le fanua chenweiliang_author mataitusi "COM", ona manaʻomia lea ona tatou faʻaogaina le SQL LIKE fuaiupu i le WHERE fuaiupu.

Fa'aaogā fa'ailoga pasene ile SQL LIKE fuaiupu %amio e fai ma sui o so'o se uiga, e tutusa ma le fetu i le UNIX po'o fa'amatalaga masani *.

Afai e leai se fa'ailoga pasene e fa'aogaina %, LIKE fuaiupu ma faailoga tutusa = E tutusa lava le aafiaga.

kalama

O loʻo taua i lalo le faʻasologa lautele o se faʻamatalaga SQL SELECT e faitau faʻamatalaga mai se laulau faʻamaumauga e faʻaaoga ai le LIKE fuaiupu:

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

• E mafai ona e faʻamaonia soʻo se tulaga i le WHERE fuaiupu.
• E mafai ona e fa'aogaina le LIKE fuaiupu i le WHERE fuaiupu.
• E mafai ona e fa'aoga le fuaiupu LIKE e suitulaga i le fa'ailoga tutusa =.
• LIKE e masani ona fesootaʻi ma % Fa'aoga fa'atasi, e pei o se su'esu'ega fa'atusa.
• E mafai ona e fa'ama'oti se tasi pe sili atu tu'utu'uga e fa'aaoga ai le MA po'o le OR.
• E mafai ona e fa'aogaina le WHERE...LIKE fuaiupu ile DELETE po'o le UPDATE poloaiga e fa'amaonia ai tulaga.

Fa'aaoga le LIKE fuaiupu i le command prompt

I lalo ifo o le a matou faʻaogaina le WHERE...LIKE fuaiupu i le SQL SELECT poloaiga e faitau faʻamatalaga mai le MySQL data table chenweiliang_tbl.

Fa'ata'ita'iga

Ole mea lea ole a tatou maua ai le fanua chenweiliang_author ile laulau chenweiliang_tbl ma Komi mo faamaumauga uma e faaiuina i le:

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)

Fa'aaogā le fuaiupu LIKE ile PHP script

E mafai ona e fa'aogaina le galuega PHP mysqli_query() ma le fa'atonuga tutusa a le SQL SELECT ma le WHERE...LIKE fuaiupu e maua ai fa'amaumauga.

O lenei galuega e faʻaaogaina e faʻatino ai faʻatonuga SQL ona tuʻuina atu lea o faʻamatalaga mo fesili uma e ala i le PHP galuega mysqli_fetch_assoc().

Ae afai o se faʻamatalaga SQL e faʻaaoga ai le WHERE...LIKE fuaiupu ile DELETE poʻo le UPDATE, e leai se manaʻoga e faʻaaoga le mysqli_fetch_array() galuega.

Fa'ata'ita'iga

O le auala lenei matou te faʻaogaina ai le PHP script e faitau ai faʻamaumauga uma e faʻaiʻu i le COM i le fanua chenweiliang_author i le laulau 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);
?>