MySQL database has wp_post table in which the post_content column is located. I need to build a SQL request so that in all posts of the post_content links of the type: http://example.com/component/tags/tag/15-text.html Replace with links of the type: http://example.com/tag/text.html That…
mysql 5.7, query to achieve this: Get least ID if repeating by message in sequence, order by ID. INPUT: id message 2485132 Process started 2485118 Process completed 2483660 Process started 2482165 Process started 2480689 Process started 2480686 Process completed 2479225…
DATE ACCOUNT VALUE 2023-06-06 1234 100 2023-06-07 1234 120 2023-06-08 1234 80 2023-06-06 3456 40 2023-06-07 3456 60 2023-06-08 3456 80 2023-06-05 5648 600 2023-06-06 5648 800 2023-06-06 5648 650 2023-06-07 5648 0 2023-06-08 5648 0 I'm passing current date…
I have a table with the following example data: ID Name lat long 1 100 123 -123 2 101 234 -234 4 100-L NULL NULL 5 100-R NULL NULL 6 101-L NULL NULL 7 101-R NULL NULL What I need…
We're building a ticketing system for our customers (enterprise clients) and we're trying to come up with a way to have a sequential, unique ticket ID generation system that is also user-friendly. Unique ID generation is a fairly well-known problem…
I am trying to search userId for value 22 from nested json in mysql Column my json is '{ "data": [ {"calendarId":"11","userId": "12"}, {"calendarId":"21","userId": "22"} ] }' I tried the following syntax : 1. where JSON_EXTRACT(column_field,'$.userId') = 22 2. where…
Table 1 and sample data:- CREATE TABLE student_p ( ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, S_id INT UNSIGNED NOT NULL, Points DOUBLE NOT NULL, P_date DATE NOT NULL ); INSERT INTO student_p VALUES (50055, 3330, 45, '2023-11-30'), (50056,…
I have a set of databases as below mysql> show databases; +------------------------+ | Database | +------------------------+ | information_schema | | sys | | system | | test | When I try to access 'test' database using the master user I'm…
I have a MySQL 5.7 table that looks like this: id meta 1 null 2 {"grant_ids": [5, 7]} I'd like to query for rows that have the presence of the value of 5 in meta-> grant_ids. I tried select *…
I have a huge 23 GB CSV file I am trying to load, and I've found that instead of converting it to insert statements which takes a while, It's possible to directly load to the DB. So I tried the…