[Mod_log_sql] need to remove forward slash from request_uri

[Edward Rudd]

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