Posts Tagged “select”

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...

Yii 2.x

Yii 2.0 db createCommand()

Feb 24, 2015

In this post I want to talk about db createCommand() and using it to fetch records instead of find(). So far you have learnt how to use find() and usi...

Yii 2.x

Yii 2.0 Using Subqueries

Feb 23, 2015

In this post I want to show you how to use subqueries in your conditions.

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...

Yii 2.x

Yii 2.0 find (SELECT)

Feb 20, 2015

In this post I want to talk about selecting (fetching) records from database. NOTE: When you want to download Yii 2.0, you can see that Yii 2.0 is not...