mysqlÕýÔò±í´ïʽ LIKE ͨÅä·û
ÓÉMySQLÌṩµÄģʽƥÅäµÄÆäËûÀàÐÍÊÇʹÓÃÀ©Õ¹ÕýÔò±í´ïʽ¡£µ±Äã¶ÔÕâÀàģʽ½øÐÐÆ¥Åä²âÊÔʱ£¬Ê¹ÓÃREGEXPºÍNOT REGEXP²Ù×÷·û(»òRLIKEºÍNOT RLIKE£¬ËüÃÇÊÇͬÒå´Ê)¡£ À©Õ¹ÕýÔò±í´ïʽµÄһЩ×Ö·ûÊÇ£º
“.”Æ¥ÅäÈκε¥¸öµÄ×Ö·û¡£
Ò»¸ö×Ö·ûÀà“[...]”Æ¥ÅäÔÚ·½À¨ºÅÄÚµÄÈκÎ×Ö·û¡£ÀýÈ磬“[abc]”Æ¥Åä“a”¡¢“b”»ò“c”¡£ÎªÁËÃüÃû×Ö·ûµÄÒ»¸ö·¶Î§£¬Ê¹ÓÃÒ»¸ö“-”¡£“[a-z]”Æ¥ÅäÈκÎСд×Öĸ£¬¶ø“[0-9]”Æ¥ÅäÈκÎÊý×Ö¡£
“ * ”Æ¥ÅäÁã¸ö»ò¶à¸öÔÚËüÇ°ÃæµÄ¶«Î÷¡£ÀýÈ磬“x*”Æ¥ÅäÈκÎÊýÁ¿µÄ“x”×Ö·û£¬“[0-9]*”Æ¥ÅäµÄÈκÎÊýÁ¿µÄÊý×Ö£¬¶ø“.*”Æ¥ÅäÈκÎÊýÁ¿µÄÈκζ«Î÷¡£
ÕýÔò±í´ïʽÊÇÇø·Ö´óСдµÄ£¬µ«ÊÇÈç¹ûÄãÏ£Íû£¬ÄãÄÜʹÓÃÒ»¸ö×Ö·ûÀàÆ¥ÅäÁ½ÖÖд·¨¡£ÀýÈ磬“[aA]”Æ¥ÅäСд»ò´óдµÄ“a”¶ø“[a-zA-Z]”Æ¥ÅäÁ½ÖÖд·¨µÄÈκÎ×Öĸ¡£
Èç¹ûËü³öÏÖÔÚ±»²âÊÔÖµµÄÈκεط½£¬Ä£Ê½¾ÍÆ¥Åä(Ö»ÒªËûÃÇÆ¥ÅäÕû¸öÖµ£¬SQLģʽƥÅä)¡£
ΪÁ˶¨Î»Ò»¸öģʽÒÔ±ãËü±ØÐëÆ¥Åä±»²âÊÔÖµµÄ¿ªÊ¼»ò½á⣬ÔÚģʽ¿ªÊ¼´¦Ê¹ÓÓ^”»òÔÚģʽµÄ½áβÓÓ$”¡£
ΪÁË˵Ã÷À©Õ¹ÕýÔò±í´ïʽÈçºÎ¹¤×÷£¬ÉÏÃæËùʾµÄLIKE²éѯÔÚÏÂÃæÊ¹ÓÃREGEXPÖØÐ´£º
ΪÁËÕÒ³öÒÔ“b”¿ªÍ·µÄÃû×Ö£¬Ê¹ÓÓ^”Æ¥ÅäÃû×ֵĿªÊ¼²¢ÇÒ“[bB]”Æ¥ÅäСд»ò´óдµÄ“b”£º
mysql> SELECT * from pet WHERE name REGEXP "^[bB]";
+--------+--------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+--------+--------+---------+------+------------+------------+
| Buffy | Harold | dog | f | 1989-05-13 | NULL |
| Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 |
+--------+--------+---------+------+------------+------------+
ΪÁËÕÒ³öÒÔ“fy”½áβµÄÃû×Ö£¬Ê¹ÓÓ$”Æ¥ÅäÃû×ֵĽáβ£º
mysql> SELECT * from pet WHERE name REGEXP "fy$";
+--------+--------+---------+------+------------+-------+
| name | owner | species | sex | birth | death |
+--------+--------+---------+------+------------+-------+
| Fluffy | Harold | cat | f | 1993-02-
Ïà¹ØÎĵµ£º
tomcat °²×°Ä¿Â¼ÏµÄconfĿ¼ÖеÄcontext.xmlÓëweb.xmlÎļþ·Ö±ðÐÞ¸ÄÈçÏ£º
context.xml мÓÈçÏÂÄÚÈÝ£º
<Resource name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://Êý¾Ý¿âµØÖ·:3306/Êý¾Ý¿âà ......
<?php
class mysql {
/*+++++++++++++++Êý¾Ý¿â·ÃÎÊÀà++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/
//=================================================
//Á¬½ÓÊý¾Ý
private $Hos ......
Ò»¡¢Apache HTTP Server °²×°£º
ÔËÐÐApache .msi Îļþ£¬°²×°³ÌÐò½«ÒªÇóÄãÌîдÈçÏÂÄÚÈÝ£º
1. Network Domain¼üÈëÄãµÄ·þÎñÆ÷£¨»òÕßÊÇÄã¼´½«×¢²áµÄ·þÎñÆ÷£©µÄDNS ÓòÃû¡£ÀýÈ磬ÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³ÆÊÇserver.mydomain.net,ÄãÖ»ÐèÔÚÕâÀïÊäÈëmydomain.net¡£
2. Server Name ¾ÍÊÇÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³Æ£¬»¹ÊÇÉÏÃæµÄÀ ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
......