Case Insensitive Like Searches In MySQL
I needed to create a query that did a case insensitive search using the LIKE command in MySQL and I quickly realised that in order to do this I would need to alter both the parameter and the table data to be the same case. This can be done by using the MySQL UPPER() command on the table data and the strtoupper() PHP function on the input data.
Connecting To A Non Standard MySQL Socket In PHP
Connecting to a MySQL database in PHP is usually not a difficult thing to do, in fact it is one of the first things that many tutorials will go though. However, there are certain curcumstances that require more information than the standard host, password and username details.
Count Number Of Characters In A String With MySQL
Today I needed to grab some data from a table where there was more than one occurrence of a string within another string. Basically, I needed to find all URL's from a table that were more than 3 levels deep (i.e. with 3 slashes), but realised there wasn't a function to do this in MySQL.
MySQL Order Table By Character Length
As part of debugging a bit of code I needed to know the longest possible field lengths that a record contains. You might need to know this if you are performing a database migration. The following query returns a field, along with the length of the string, and orders the results by the number of characters in that string.
Backup MySQL Database PHP Script
There are quite a few scripts available on the Internet that allow you to dump data from a database into a format that can be used to replicate that database structure elsewhere. The following function is my take on this commonly occurring script.
Convert A String To A Date Value In MySQL
There are numerous ways to print out dates and times, and many hours of programming are spent in converting dates from one format to another.
Deep appreciation for outlining this process!
Submitted by Corey on Sun, 06/05/2011 - 22:27Permalink
Submitted by brandon on Thu, 08/16/2012 - 01:28Permalink
Submitted by blogwidget on Sat, 08/25/2012 - 07:18Permalink
net start "name of the sql service"
Submitted by Saji on Sat, 07/17/2021 - 10:21Permalink
Add new comment