MYSQL ¶à¹Ø¼ü×ÖÏà¹ØÎÄÕ²éѯ·½·¨
È¡µÃÎÄÕ¹ؼü×ÖΪkeywords
±ínewsµÄ¹Ø¼ü×Ö×Ö¶ÎΪkeyword
keywords=keywords.replace(',','|');
String sql="SELECT * from news WHERE keyword REGEXP '"+keywords+"' ORDER BY id ";
ÓÉÓÚijЩÔÒò£¬ÓÐʱºòÎÒÃÇûÓа´ÕÕ·¶Ê½µÄÉè¼Æ×¼Ôò¶ø°ÑһЩÊôÐԷŵ½Í¬Ò»¸ö×Ö·û´®×Ö¶ÎÖС£±ÈÈç¸öÈËÐËȤ£¬ÓÐʱºòÎÒÃÇÉè¼Æ±íΪ
create table members (uid int primary key,uname varchar(20),hobby varchar(100));
±íÖÐÄÚÈÝÈçÏÂ
mysql> select * from members;
+-----+-------+---------------------------------+
| uid | uname | hobby |
+-----+-------+---------------------------------+
| 1 | AAAA | ÒôÀÖ,µçÓ°,ÍøÂç,ÀºÇò,ÔĶÁ,ƹÅÒÇò |
| 2 | BBBB | ÒôÀÖ,ÔĶÁ,ƹÅÒÇò,·¢´ô,ΧÆå,²Îìø |
| 3 | CCCC | ½»ÓÑ,ƹÅÒÇò |
| 4 | DDDD | ̨Çò,ÍøÂç,¿´Êé,ÂÃÓÎ |
| 5 | EEEE | ÒôÀÖ,·¢´ô,ÏÂΧÆå,²Îìø |
+-----+-------+---------------------------------+
4 rows in set (0.00 sec)
Èç¹ûÎÒÃÇÏÖÔÚÏë²éÕÒÒ»¸öÓëij¸öÓû§X (ÔĶÁ,½»ÓÑ,ΧÆå,×ãÇò,»¬Ñ©)ÓÐ×ÅÏàͬ°®ºÃµÄ»áÔ±¼Ç¼ Èç¹ûÀ´²Ù×÷ÄØ£¿
ÔÚÆäËüÊý¾Ý¿âÖУ¬ÎÒÃÇÄÜֻͨ¹ý³ÌÐòÀ´»òÕß´æ´¢¹ý³ÌÀ´·Ö½âÕâ¸ö "ÔĶÁ,½»ÓÑ,ΧÆå,×ãÇò,»¬Ñ©" ×Ö·û´®Îªµ¥¶ÀµÄ°®ºÃÏîÄ¿£¬È»ºóÒ»¸öÒ»¸ö½øÐÐ like '%xxxx%' À´²éѯ¡£ µ«ÔÚMySQLÖÐÎÒÃÇ¿ÉÒÔÖ±½ÓÀûÓÃÕâ¸öregexpÕý¹æ±í´ïʽ À´¹¹ÔìSQLÓï¾äÀ´ÊµÏÖ¡£
Ê×ÏÈÎÒÃÇ°Ñ 'ÔĶÁ,½»ÓÑ,ΧÆå,×ãÇò,»¬Ñ©' ת»»³ÉΪÕýÔòʽ Ϊ 'ÔĶÁ|½»ÓÑ|ΧÆå|×ãÇò|»¬Ñ©' , | ÔÚÕýÔò±í´ïʽÖÐΪ '»ò' µÄÒâ˼
mysql> select replace('ÔĶÁ,½»ÓÑ,ΧÆå,×ãÇò,»¬Ñ©',',','|');
+---------------------------------------------+
| replace('ÔĶÁ,½»ÓÑ,ΧÆå,×ãÇò,»¬Ñ©',',','|') |
+---------------------------------------------+
| ÔĶÁ|½»ÓÑ|ΧÆå|×ãÇ
Ïà¹ØÎĵµ£º
(1)
Íâ¼üµÄʹÓÃ:
Íâ¼üµÄ×÷ÓÃ,Ö÷ÒªÓÐÁ½¸ö:
Ò»¸öÊÇÈÃÊý¾Ý¿â×Ô¼ºÍ¨¹ýÍâ¼üÀ´±£Ö¤Êý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ.
Èç:
ÓбíA,±íBÖÐÒ»×Ö¶ÎÊDZíAijһ×ֶεÄÍâ¼ü.µ±É¾³ý±íA¼Ç¼ʱ,±íBÏàÓ¦¼Ç¼»á×÷ÏàÓ¦´¦Àí(ɾ³ý/»òÉèÖÃÍâ¼üÁÐΪNULL).µ«Èôɾ³ý±íB¼Ç¼,±íAµÄ¼Ç¼,Ôò²»»áÊÜÓ°Ïì!
Ò»¸ö¾ÍÊÇÄܹ»Ôö¼ÓERͼµÄ¿É¶ÁÐÔ
&nbs ......
ʹÓÃÁÙʱ±íµÄºÃ´¦£º
ʹÓÃÁÙʱ±í´æ·ÅÖмä½á¹û,¼ÓËÙ²éѯ£¬»ò´æ·ÅÁÙʱ½á¹û.
(1)
´´½¨ÁÙʱ±íºÜÈÝÒ×£¬¸øÕý³£µÄCREATE TABLEÓï¾ä¼ÓÉÏTEMPORARY¹Ø¼ü×Ö£º
CREATE TEMPORARY TABLE tmp_table (
name VARCHAR(10) NOT NULL,
value INTEGER NOT NULL
)
(2)
ÁÙʱ±í½«ÔÚÄãÁ¬½ÓMySQLÆÚ¼ä´æÔÚ¡£µ±Äã¶Ï¿ªÊ±£¬MySQL ......
ÅäÖãº
binlog:ÓÃÓÚÔöÁ¿±¸·Ý
errorlog:¼à¿Ø´íÎóÐÅÏ¢
slow_query_log:¼à¿Ø²éѯ³¬Ê±µÄSQLÓï¾ä
data directory:Ìá¸ßÐÔÄÜ£¬±ãÓÚ¹ÜÀí
Ñ¡ÔñĬÈÏÊý¾Ý¿âÒýÇæ
INNODBÊý¾Ý¿âÒýÇæµÄÊý¾ÝĿ¼:Ìá¸ßÐÔÄÜ£¬±ãÓÚ¹ÜÀí
log_bin_trust_routine_creators=1 Èç¹û¸´ÖÆϵͳÀïÓÐʹÓõ½Óû§×Ô¶¨Ò庯Êý»ò´æ´¢¹ý³Ì ......
ÔÚÏò´ó¼ÒÏêϸ½éÉÜLinux mysql֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂLinux mysql£¬È»ºóÈ«Ãæ½éÉÜLinux mysql£¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£
1. Linux mysql°²×°£º
$ yum install mysql-server
2. Linux mysqlÐÞ¸ÄrootÃÜÂ룺
$ mysqladmin -u root password
your_new_passwd
3. Æô¶¯Linux mysql·þÎñ
$ /etc/init.d/mysqld start
4. Ìí¼ÓΪϵͳ· ......
1¡¢°²×°Ä¿Â¼:
½«my.iniÖÐ:
datadirµÄÖµ¸ü¸ÄΪ£º"sql/data/"
basedirµÄÖµ¸ü¸ÄΪ£º"sql"
2¡¢½øÈësql/data/"£¬É¾³ýÎļþ¼ÐÍâµÄËùÓÐÎļþ¡£
net start mysql»Ø³µ……
×¢ÒâбÏß/
ÐÞ¸Äpswd
·½·¨1£ºmysqladmin -u root -p "old password" "new password" (´ËÃüÁîÎÞ·¨°ÑÃØÃÜÇå¿Õ)
·½·¨2£º ......