Friday, 27 November 2009
Friday, 13 November 2009
mysql and regular expressions
The first time I needed to have some kind of complex select statement, I started to pray about the ability to use regular expressions with mysql.
Easy as it may be: use REGEXP!
For example:
SELECT * FROM db.ip_addresses WHERE ip_address REGEXP '^192\.168\.0\.(133|135)$';
See the official documentation and details here.
Easy as it may be: use REGEXP!
For example:
SELECT * FROM db.ip_addresses WHERE ip_address REGEXP '^192\.168\.0\.(133|135)$';
See the official documentation and details here.
Friday, 6 November 2009
Now save and quit... doh!
If you like me are annoyed by the "recording" feature on vim (or better, by the way you can accidentally start it), then you may find at least useful to learn how it can be actually used.
This post explains it.
This post explains it.
Subscribe to:
Comments (Atom)
-
WebRTC applications use the ICE negotiation to discovery the best way to communicate with a remote party. I t dynamically finds a pair of... -
I needed an efficient way to programmatically extract RTP streams from a network capture. In addition I wanted to: save each stream into a s...
-
There are various levels of testing, from unit to component, from integration to end-to-end, not to mention performance testing and fuzzing....