Category: “SQL”

SQL

MySQL Sorting Persian Data

Feb 14, 2016

Introduction: When sorting Persian data in mysql, Persian letters (گ,چ,پ,ژ) are not placed in the right order and they will appear after other letters...

SQL

Fetching Records from Database

Feb 21, 2015

In this post I want to talk about fetching records from your database using SQL Syntax. As always, let's start with an example. Imagine we have one ta...

SQL

Pagination, OFFSET, LIMIT

Feb 16, 2015

In this post I want to talk about LIMIT and OFFSET and how to use them, to paginate your results when you are developing a website. Let's start with a...