Search Rantburg

Search Submit
contains1 Scott Beauchamp
pfrom 2002-05-09
pto 2018-05-06
Search Rantburg

select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-05-09' and rdate <= '2018-05-06') as y where lower(rquote) like '%scott beauchamp%' order by id desc limit 100

1	214330	12/20/2007	Victor Davis Hanson - Has War Changed, or Have We?
2	196362	08/16/2007	62 Counts of Journalistic Mistakes and Media Screw Ups
3	196253	08/15/2007	Terrorist Propaganda Picture of the Week
4	195233	08/03/2007	Beauchamp's Story 'Proven to Be False'
5	195230	08/03/2007	Army: Beachamp Investigation Concluded

How many records?
Start Date?		End Date?
Look for (no quotes, separate by commas, example: abu sayaf,jemaah islamiya,moro islamic liberation front)