mlsamuelson.com
RLIKE - use Regex in MySQL SELECT statements
SELECT title FROM periodicals WHERE title RLIKE '^National .* Weekly$';
match all rows where title starts with 'National' and ends with 'Weekly' with anything in between
Matches
National Work Workers Weekly
National Policy Review Weekly
Nationalist Critique Weekly
Not
National Lampoon Magazine
Mountaineering Weekly
No comments
Via Twitter
Archives
- July, 2008 (1)
- August, 2008 (5)
- September, 2008 (5)
- October, 2008 (1)
- November, 2008 (1)
- December, 2008 (1)
- January, 2009 (1)
- April, 2009 (2)
- May, 2009 (1)
- July, 2009 (1)
Add your comment