How to read a particular tag data from longtext type in mysql?

I am new to database so please advise me how to read data from a longtext(clob data type) in my sql.

The longtext field name is Rest_Server and the value tag to be read is from that.

Solution

select substr(clob_column,INSTR(clob_column,''),lengthOfTag) from table

I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
find number of rows in returned mysql result (nodejs)
Get records that have total count of over X amount
Excluding records between dates AND with an associating value
MYSQL Update query, replace part string containing URL
MySQL Not Equal To Certain Length
How can I solve "Error: MySQL shutdown unexpectedly"?
How do I turn off the mysql password validation?
How to create table like another table with additional columns in MYSQL
How import also column name in CSV file
Export Column Names to CSV
split characters and numbers in MySQL
If only CI fails, what kind of trouble could there be for django?
Perform an INNER JOIN with more than 2 tables in MySQL
Imploding a list for use in a Python MySQL IN clause
SQL check if timestamp is greater than 24 hours from now (MYSQL)
SQL - Query to find if a string contains part of the value in Column
MySQL stored function: CONTAINS SQL or NO SQL?
MySQL "delayed commit ok done" and performance
MySQL Query performance - best partial match
MySQL: How to reset or change the MySQL root password?
How to reset the root password in MySQL 8.0.11?
Count 'IN' value in MySQL from multiple non-normalized columns
coupon code statistics
How to return NULL when result is empty?
Extract dirname from full path stored in database
Using larger than or equal (>=) to in PreparedStatement in Java
What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?
Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax
How to find the minimum of a sum of values based on a distinct value?