How to use ORDER BY TRIM(BOTH '"' FROM name); ???

E

eldar_web2015-03-18 11:41:01

Yii

eldar_web, 2015-03-18 11:41:01

I want to exclude quotes when selecting records from the database in YII (due to alphabetical sorting), but how can I use TRIM(BOTH '"' FROM name) ???

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

NO, 2015-03-18
@eldar_web

Read documentation: yiiframework.com/doc/guide/1.1/en/database.query-b... or in Russian: yiiframework.com/doc/guide/1.1/en/database.query-b...

Similar questions

E

Evgeny Kucherenko2017-06-08 18:02:39

How to perform synchronous iteration of an array? 4Reply

N

nepster-web2014-12-16 16:08:00

Yii2 session in database, how to determine userId? 1Reply

A

Alexander Sinitsyn2016-12-13 15:09:43

How to tell ActiveForm which script to use for client-side validation? 1Reply

V

Vasily2016-12-14 06:07:09

How to reload a file with JavaScript when re-AJAX-rendering the same view-file containing a link to this JavaScript-file? 1Reply

E

Elena2016-12-14 12:24:21

How to set PATH environment variable in yii2 codeception? 1Reply

Didn't find what you were looking for?

Ask your question