MySQL Archives - Page 8 of 77

Java, Programming

IT Nursery

Using “like” wildcard in prepared statement

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on a keyword of ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How can I tell when a MySQL table was last updated?

In the footer of my page, I would like to add something like “last updated the xx/xx/200x” with this date being the last ...

May 31, 2022
0 Comments

WordPress

IT Nursery

Emojis getting converted to “?”

Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The ...

May 31, 2022
0 Comments

WordPress

IT Nursery

Get the Plugin Which Triggered a MySql Query in WordPress?

I am currently working on this plugin, which is similar to Query Monitor in which i Have displayed all the Details present in ...

May 31, 2022
0 Comments

PHP, Programming

IT Nursery

PHP/MySQL insert row then get ‘id’

The ‘id’ field of my table auto increases when I insert a row. I want to insert a row and then get that ...

May 31, 2022
0 Comments

WordPress

IT Nursery

Find duplicate posts with same slug and author

We imported over 250K posts into our multi-author WordPress database but have found duplicate posts where the same author has multiple posts with ...

May 31, 2022
0 Comments

WordPress

IT Nursery

How to delete posts that does not have a thumbnail?

I have a problem with my blog. The thing is this, all the posts have a thumbnail in this address: wpbv_postmeta-->meta_key-->thumb And several ...

May 31, 2022
0 Comments

WordPress

IT Nursery

Keeping database within limits, please help!

I have a website that auto generates odds data to mysql table via cron job every 2hrs. Over time the data in my ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Add 2 hours to current time in MySQL?

Which is the valid syntax of this query in MySQL? SELECT * FROM courses WHERE (now() + 2 hours) > start_time note: start_time ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Copy values from one column to another in the same table

How can I make a copy values from one column to another? I have: Database name: list ------------------- number | test ------------------- 123456 ...

May 31, 2022
0 Comments