sql — Библиотека кода

SQL select phone

Sql phone sql получить из строки только цифры sql регулярные выражения Sql запрос для получения номера телефона без букв, пробелов, и спец символов

select *, 
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(phone, '-', ''), ' ', ''), '+', ''), '(', ''), ')', '') as 'Телефон' 
from table

select *,

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(phone, '-', ''), ' ', ''), '+', ''), '(', ''), ')', '') as 'Телефон'

from table

Если версия mysql >= 8

select regexp_replace(phone, '[^[:digit:]]', '') from table

1	select regexp_replace(phone, '[^[:digit:]]', '') from table

mysql, sql

LeftJOIN Получить категории

return ShopProduct::find()
    ->select(
        ShopProduct::tableName() . '.name pn, 
        ' . ShopProduct::tableName() . '.path pp, 
        lvl1.name l1n, lvl1.path l1p,
        lvl2.name l2n, lvl2.path l2p, 
        lvl3.name l3n, lvl3.path l3p'
    )
    ->leftJoin(ShopCategory::tableName() . ' lvl1',  ShopProduct::tableName() . '.cat_id = lvl1.id')
    ->leftJoin(ShopCategory::tableName() . ' lvl2', 'lvl1.parent_id = lvl2.id')
    ->leftJoin(ShopCategory::tableName() . ' lvl3', 'lvl2.parent_id = lvl3.id')
    ->where([ShopProduct::tableName() . ".id" => $id])
    ->asArray()
    ->one();

return ShopProduct::find()

->select(

ShopProduct::tableName() . '.name pn,

' . ShopProduct::tableName() . '.path pp,

lvl1.name l1n, lvl1.path l1p,

lvl2.name l2n, lvl2.path l2p,

lvl3.name l3n, lvl3.path l3p'

)

->leftJoin(ShopCategory::tableName() . ' lvl1', ShopProduct::tableName() . '.cat_id = lvl1.id')

->leftJoin(ShopCategory::tableName() . ' lvl2', 'lvl1.parent_id = lvl2.id')

->leftJoin(ShopCategory::tableName() . ' lvl3', 'lvl2.parent_id = lvl3.id')

->where([ShopProduct::tableName() . ".id" => $id])

->asArray()

->one();