SELECT CONCAT(SUBSTRING_INDEX(withLink,'<', 1), REPLACE(SUBSTRING_INDEX(withLink,'>', -2),'</a>','')) as withoutLink FROM ...
-- for testing
SELECT 'something <a href="telnet://192.168.1.1">some text</a> dasdsdgdfg' as withLink, (SELECT CONCAT(SUBSTRING_INDEX(withLink,'<', 1), REPLACE(SUBSTRING_INDEX(withLink,'>', -2),'</a>',''))) as withoutLink$stmt = $dbLFSP->prepare("SELECT online, username FROM users WHERE online = :hostname");
$stmt->bindValue(':hostname',$hostname);
$stmt->execute();
$users = $stmt->fetchAll();SELECT CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX('/a/b/c/110/h4eheh.jpg','/',-2),'/',1),'_somestring.',SUBSTRING_INDEX('/a/b/c/110/h4eheh.jpg','.',-1)) as imageSET @q = '/a/b/c/110/h4eheh.jpg';
SET @a1 = SUBSTRING_INDEX(SUBSTRING_INDEX(@q,'/',-2),'/',1);
SET @a2 = SUBSTRING_INDEX(@q,'.',-1);
SELECT @q, CONCAT(@a1,'_somestring.',@a2),@a2iptables -t nat -D zone_lan_postrouting -s 192.168.6.0/24 -d 192.168.6.114/32 -p tcp -m tcp --dport 29339:30000 -m comment --comment "lfsp (reflection)" -j SNAT --to-source 192.168.6.14iptables -t nat -A zone_lan_postrouting -s 192.168.6.0/24 -d 192.168.6.114/32 -p tcp -m tcp --dport 29339:30000 -m comment --comment "lfsp (reflection)" -j SNAT --to-source 85.113.ххх.ххх