UPDATE your_table SET url = REPLACE(url, 'test/1', 'test/2') WHERE url LIKE '%test/1%'
Tag Archives: example
Vim: Replace Regex Örnekleri
Örnek-1:
Mevcut format:
public $hosts; public $ldap_servers; public $ldap_port; public $ldap_encrypt; public $ldap_rootdn; public $ldap_password; public $ldap_base; public $ldap_uids;
İstenilen format:
hosts, ldap_servers, ldap_port, ldap_encrypt, ldap_rootdn, ldap_password, ldap_base, ldap_uids,
Replace regex:
:51,58s/public \$\(.*\);/\1,/gi