Recent content by sbutt

on doing so: SELECT integra_msg_monitor.msg_name, integra_msg_monitor.msg_date, integra_msg_monitor.msg_time FROM IntegraDB.integra_msg_monitor integra_msg_monitor where integra_msg_monitor.msg_name LIKE '%' and integra_msg_monitor.msg_date BETWEEN convert(datetime, 'Oct 23 2012...

hi folks, I have a table in mysql 5, which contains some date value (dd.mm.yyyy), but the column type is varchar. Now i want to query certain rows based on a given date range. My query is the following: SELECT integra_msg_monitor.msg_name, integra_msg_monitor.msg_date...