SELECT REPLACE(JID , '@127.0.0.1' , '') , JID FROM TABLE_NAME WHERE ROOMID = 1;
ORACLE REPLACE语法
最新推荐文章于 2024-02-23 09:03:00 发布
SELECT REPLACE(JID , '@127.0.0.1' , '') , JID FROM TABLE_NAME WHERE ROOMID = 1;