MySQL

All entries about MySQL!
^Top
<< Back










Highlighted Entries

Members Area

Top 50

Last Modified

Last Created

In Progress


Sub Categories

Simple Operations
Operations

Simple Operations

Delete Database SQL Entries [Delete From]

Views: 789 Created: 2020-06-15 19:01:44 Modified: 2023-03-20 20:54:32
Delete with Condition:<br /> DELETE FROM&nbsp;tablename WHERE a = 1; Delete all entries in a table:<br /> DELETE FROM tablename; ...

Operations

How to replace String in Text with SQL

Views: 460 Created: 2021-11-30 17:22:34 Modified: 2023-03-29 06:44:04
Here is an example how to replace for example the string &quot;https://test.de/testthis/&quot; with &quot;https://newlink.de/testthis/&quot;. The code is: UPDATE tablenamehere<br /> SET columnname = REPLACE(columnname , &#39;test.de&#39;, &#39;newlink.de&#39;); ...

This Website is using Session Cookies for Site Functionality.