Author Archives: user

SQL – Injection Table of content If you take a user input through a webpage and insert it into an SQL database, there is a chance that you have left yourself wide open for a security issue known as the SQL Injection. This chapter will teach you how to help prevent this from happening and […]

SQL – Wildcards SQL Wildcards SQL Wildcards are special characters used as substitutes for one or more characters in a string. They are used with the LIKE operator in SQL, to search for specific patterns in character strings or compare various strings. The LIKE operator in SQL is case-sensitive, so it will only match strings […]

SQL – MIN() – MAX() function Table of content The MIN() and MAX() functions in SQL are aggregate functions. They are used to compare values in a set and, retrieve the maximum and minimum values respectively. An aggregate function is a mathematical computation that takes a range of values as input and yields a single […]