note 104965 deleted from function.preg-replace by crell

Note Submitter: sreekanth at outsource-online dot net ---- if your intention to code and decode mod_rewrite urls and handle it with php and mysql ,this should work to convert to url $url = preg_replace('/[^A-Za-z0-9_-]+/', '-', $string); And to check in mysql with the url value,use the same expression discounting '-'. first replace the url value with php using preg_replace and use with mysql REGEXP $sql = "select * from table where fieldname_to_check REGEXP '".preg_replace("/-+/",'[^A-Za-z0-9_]+',$url)."'"