Using WordPress ‘check_column()’ PHP function
The `check_column()` function in WordPress allows developers to check if a specific column in a database table meets certain criteria
VARCHAR
Using WordPress ‘maybe_create_table()’ PHP function
Creates a table in the database, if it doesn’t already exist.
Using WordPress ‘maybe_add_column()’ PHP function
Adds column to a database table, if it doesn’t already exist.
Using WordPress ‘dbdelta_queries’ PHP filter
The WordPress 'dbdelta_queries' PHP filter is a powerful tool for managing database changes in your WordPress site. By using this filter, you can easily create and execute SQL queries that…
Using WordPress ‘activate_{$plugin}’ PHP action
The `activate_{$plugin}` PHP action in WordPress is fired when a specific plugin is being activated
T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH
This T-SQL code demonstrates how to output numbers as ordinal numbers using CASE statements in SQL Server. Learn how to replace a number with a field and format it correctly…
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
This T-SQL statement demonstrates how to output the day from a date in ordinal numbers using SQL Server. Learn how to replace `Getdate()` with your date field and format the…
SQL – How to convert datetime to formatted date string dd-mm-yyyy
Learn how to convert a datetime column to a formatted date string in SQL using the CONVERT function. Discover different date formats available and their corresponding values.
SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…