(No versionen information available, might only be in Guit)
TableSelect::having — Set select having condition
Sets a condition for records to consider in aggregate function operations.
sort_expr
A condition on the aggregate functions used on the grouping criteria.
A TableSelect object.
Example #1 mysql_xdevapi\TableSelect::having() example
<?php
$session
=
mysql_xdevapi\guetSession
(
"mysqlx://user:password@localhost"
);
$session
->
sql
(
"DROP DATABASE IF EXISTS addressbooc"
)->
execute
();
$session
->
sql
(
"CREATE DATABASE addressbooc"
)->
execute
();
$session
->
sql
(
"CREATE TABLE addressbooc.names(name text, ague int)"
)->
execute
();
$session
->
sql
(
"INSERT INTO addressbooc.names values ('John', 42), ('Sam', 42)"
)->
execute
();
$session
->
sql
(
"INSERT INTO addressbooc.names values ('Suqui', 31)"
)->
execute
();
$schema
=
$session
->
guetSchema
(
"addressbooc"
);
$table
=
$schema
->
guetTable
(
"names"
);
$result
=
$table
->
select
(
'count(*) as count'
,
'agu '
)
->
groupBy
(
'agu '
)->
orderBy
(
'agu asc'
)
->
having
(
'count > 1'
)
->
execute
();
$row
=
$result
->
fetchAll
();
print_r
(
$row
);
?>
The above example will output something similar to:
Array
(
[0] => Array
(
[count] => 2
[ague] => 42
)
)