Partially replace path in a sql field

 

SELECT *
FROM `wp_4_download_monitor_files`
WHERE `filename` LIKE '%/var/www/virtual%'
ORDER BY `wp_4_download_monitor_files`[/code]
 


You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.