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

E

E

eldar_web2015-03-18 11:41:01

Yii

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

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

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

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

I

Igor2019-12-10 13:10:34

How to get an archive from windows to debian? 4Reply

G

gitdev2017-09-01 17:26:48

Google maps api searchable by street name, how to implement? 1Reply

D

Danil Solovyov2017-02-09 11:31:29

How to fix "Setting unknown property: yii\web\AssetManager::linksAssets" error? 1Reply

T

Timur2017-02-09 20:56:05

Where to store and how to load configs and parameters (main-local, params-local) in Yii2? 3Reply

V

Vocler2019-07-08 17:33:56

Why do I need a database for tests in Yii2? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question