Use MySQL Regexp Sample

Published on August 10, 2010 in MySQL. 0 Comments Tags: MySQL, regexp.

1	DELETE FROM `google_data` WHERE site_id=4 AND url REGEXP '\.php\\?matchid=[0-9]+$'

Related Posts

April 28, 2012 -- 优化MySQL语句的十个建议
January 18, 2012 -- MySQL regex_replace Function
June 9, 2011 -- 一天总结
September 13, 2010 -- MySQL锁表机制分析
September 9, 2010 -- HOWTO: configure MySQL’s my.cnf file
September 8, 2010 -- MySQL性能优化21 – 使用随机函数产生采样
September 8, 2010 -- MySQL性能优化20 – ORDER BY 操作的优化
September 8, 2010 -- MySQL性能优化19 – GROUP BY 操作的优化
September 8, 2010 -- MySQL性能优化18 – 使用 GROUP BY WITH ROLLUP 改善统计性能
September 8, 2010 -- MySQL性能优化17 – INSERT操作的优化

0 Responses to “Use MySQL Regexp Sample”

Feed for this Entry Trackback Address

No Comments

Leave a Reply