User contributions
23 October 2007
Working with Dates and Times in MySQL
New page: In this chapter of MySQL Essentials we are going to look at storing dates and times in a database table and also retrieving and manipulating these values. == Date and Time Formats == ...
MySQL Essentials
no edit summary
+30
22 October 2007
MySQL Essentials
no edit summary
+9
MySQL Essentials
no edit summary
+50
MySQL Calculations and Concatenations
Trimming Whitespace from Text
+54
MySQL Calculations and Concatenations
Trimming Whitespace from Text
+120
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+5,650
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+61
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+778
MySQL Calculations and Concatenations
New page: When is retrieved from a MySQL database it is not always in the form we need it. For example, we may need to display a customer name and address as a single test string, but in reality the...
MySQL Essentials
no edit summary
+44
Joining Tables in MySQL
Equi-Join (aka the Inner Join)
+5,071
Joining Tables in MySQL
How Does a Join Work?
+5,282
19 October 2007
Joining Tables in MySQL
New page: Table joins provide a way of associating data that resides in different tables during data retrieval. Suppose we have a table in our MySQL database called ''product''. This table contains ...
MySQL Essentials
no edit summary
+30
MySQL Regular Expression Searches
Regular Expressions and Whitespace Characters
-2
MySQL Regular Expression Searches
Matching by Text Position
+6
MySQL Regular Expression Searches
Matching by Text Position
+926
MySQL Regular Expression Searches
Matching by Text Position
+274
MySQL Regular Expression Searches
Matching by Text Position
MySQL Regular Expression Searches
Matching by Text Position
+13
MySQL Regular Expression Searches
Matching by Text Position
+299
MySQL Regular Expression Searches
Matching by Character Type
-9
MySQL Regular Expression Searches
Matching by Character Type
+187
MySQL Regular Expression Searches
Matching by Character Type
+9
MySQL Regular Expression Searches
Matching by Character Type
+15
MySQL Regular Expression Searches
Matching by Character Type
+2
MySQL Regular Expression Searches
Matching by Character Type
+24
MySQL Regular Expression Searches
Matching by Text Position
+260
MySQL Regular Expression Searches
no edit summary
-26
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+387
MySQL Regular Expression Searches
Location Specific Matches
-352
MySQL Regular Expression Searches
Location Specific Matches
+319
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+1
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+2,842
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+49
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+377
MySQL Regular Expression Searches
Matching by Character Type
-2
MySQL Regular Expression Searches
no edit summary
+1,066
16 October 2007
MySQL Regular Expression Searches
Matching by Character Type
+35
MySQL Regular Expression Searches
Regular Expression Repetition Metacharacters
+127
MySQL Regular Expression Searches
Matching by Character Type
+52
MySQL Regular Expression Searches
Matching by Character Type
+1
MySQL Regular Expression Searches
Matching by Character Type
+5
MySQL Regular Expression Searches
Regular Expressions and Whitespace Characters
+1,399
MySQL Regular Expression Searches
Regular Expressions and Whitespace Characters
-4
MySQL Regular Expression Searches
Handling Special Characters
+2,897
MySQL Regular Expression Searches
Matching from a Range of Characters
+35
MySQL Regular Expression Searches
New page: In previous chapters we have looked at some basic data retrieval filtering techniques using comparison operators and wildcards. Whilst this approaches to data filtering are fine for basic ...
MySQL Wildcard Filtering using LIKE
Summary
+1