String Functions

Using Wildcards In MySQL LIKE Clause – With Examples

Using wildcards in the LIKE clause of a MySQL query can save a lot of effort when you write a query that looks for a pattern in a character string. Just as a refresher, the standard wildcard characters are: % substitute for any characters at the BEGINING or END of the string. _ substitute for any single character. […]

Using Wildcards In MySQL LIKE Clause – With Examples Read More »

How do I add a zero in front of a string in SQL? 2 Easy Ways and 1 Weird Way

String Functions / Rob Mills

How do I add a zero in front of a string in SQL? 2 Easy Ways and 1 Weird Way There are several ways to add a zero to a string in SQL, with minor syntax differences depending on what database you’re using. Let’s start with the easiest method, string concatenation with sample code for

How do I add a zero in front of a string in SQL? 2 Easy Ways and 1 Weird Way Read More »