We know that when filtering text data in a MySQL WHERE clause conditional, strings are placed in single quotes. In this blog post, learn how to filter numeric data in a MySQL WHERE clause conditional…
(more…)Database Developer
MySQL WHERE Clause Equality Comparison Operator
We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…
(more…)Create Table Structure From Existing Table in Oracle SQL
Do you need the same table structure as an existing table in your database, but empty of rows? Oracle SQL’s CREATE TABLE AS statement achieves this easily. Continue reading and learn how with a simple example…
(more…)SQL INSTR() Function – Medium Cross Post
Character and text data are such an integral component of data that most all programming languages provide many functions, constructs, and even libraries to help process text data. I recently used the Oracle SQL INSTR() function in some text-parsing queries. However, these queries were not standalone INSTR() only. INSTR() is also quite powerful as a parameter for other string functions, namely SUBSTR(), in this example. Continue reading to learn more…
(more…)SQL Joins – A Simple Guide
If you are working with SQL relational databases, at some point you are going to use JOINs. Normalized data is organized and spread across multiple tables, oftentimes linked by a common column key (or multiple keys). We use JOINs to bring the data together. Therefore JOINs are an important concept to grasp. There are SQL JOIN articles and guides across the internet far and wide and I am adding one more into the mix…
(more…)