how to get count from select query ?

Hello, how to get count from select query ? Example.

"select * from table where name like %aa%; == '$table=DB::table('table')->where('number','LIKE', '%аа%')'
SELECT FOUND_ROWS(); == ??;

i am sorry, i have bad English;

Level 75

If you are new to programming you should seriously consider taking a SQL basic course or tutorial.

"select count (id) as mycount from table where name ..."

Level 47

DB::table('table')->where('number', 'LIKE', '%aa%')->count();

Please or to participate in this conversation.