SELECT *
FROM table
WHERE lower(column) = 'testtest';
или использовать ILIKE. Если массив replacement содержит меньше элементов, чем массив pattern, то все лишние шаблоны из pattern будут заменены пустыми строками.
'/.*/'
заменён пустой строкой buttons.map((item) => {
let one = item.one;
let two = item.two;
return (`${one} ${two}`)
})
$equipment = Type::find()->indexBy('id')->asArray()->all();
$equipment = array_map(function ($row) use ($equipment) {
$row['parent_name'] = isset($equipment[$row['parent_id']]) ? $equipment[$row['parent_id']]['name'] : null;
return $row;
}, $equipment);
$equipment = array_filter($equipment, function ($row) {
return $row['parent_name'];
});
$result = ArrayHelper::map($equipment, 'id', 'name', 'parent_name');
$equipment = Type::find()->indexBy('id')->asArray()->all();
$equipment = array_map(function ($row) use ($equipment) {
$row['parent_name'] = isset($equipment[$row['parent_id']]) ? $equipment[$row['parent_id']]['name'] : $row['parent_id'];
return $row;
}, $equipment);
$result = ArrayHelper::map($equipment, 'id', 'name', 'parent_name');
if(isset($result[0])) {
unset($result[0]);
}
.nav-menu {
display: flex;
justify-content: space-around;
align-items: center;
padding: 0;
margin-top: 2%;
border: 1px solid #e7e7e7;
background: #f3f3f3;
list-style: none;
height: 2.5rem;
}
.nav-menu li{
display: flex;
flex : 1 1 auto;
height: 2.5rem;
}
.nav-menu a {
margin: auto 0;
text-transform: uppercase;
color: #c8c8c8;
text-decoration: none;
font-size: .875rem;
text-align: center;
width: 100%;
}
.nav-menu li:hover,
.nav-menu li:hover a{
color: #fff;
background: #29c5e6;
}
.links {
width: 100%;
height: 50px;
background: #f3f3f3;
border-bottom: 1px solid #e7e7e7;
}
.links ul {
display: flex;
justify-content: space-around;
align-items: center;
padding-top: 15px;
List-style: none;
}
.links ul li a {
display: block;
text-decoration: none;
color: #8f8f8f;
text-transform: uppercase;
font-size: 1.125rem;
font-weight: 300;
}
.links span {
margin-right: 10px;
padding: 0 10px;
width: 24px;
height: 24px;
background: #8f8f8f;
color: #fff;
}
.links ul li:hover a {
color: #29c5e6;
}
.links ul li:hover span {
background: #29c5e6;
color: #fff;
}