[Mod_log_sql] need to remove forward slash from request_uri

Edward Rudd urkle at outoforder.cc
Mon Feb 16 18:17:02 EST 2009

The simplest is to use SQL to remove the first character from the  
field when selecting

SELECT SUBSTRING(request_uri,2) as request_uri FROM myloggingtable

On Feb 16, 2009, at 4:25 PM, jeffs wrote:

> I have mysql logging working perfectly.  I only need to either:
> a) use some mysql command to remove the forward slash from uri that is
> being input into the uri_request field, or
> b) stop the forward slash from being recorded in the mysql database in
> the first place.
> Either way, I need to not have the forward slash get recorded into the
> request_uri field.  In this particular logging scenario I am using,
> uri's will always look like:
> /098sdafmasf90q89234rjqwe.jpg
> as recorded by log_mysql.
> I need it to look like:
> 098sdafmasf90q89234rjqwe.jpg
> is there a way to do this?
> Thank you very much
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> To unsubscribe send an e-mail to
> mod_log_sql-unsubscribe at lists.outoforder.cc

More information about the Mod_log_sql mailing list