> where ID = count() <= 5 , if ..
>
> In other words Count wouldn't be looking for an ID
> with a value of 5, but the number of records the ID
> has in the table .
SELECT count(*) AS users_records_number
FROM table
WHERE user_id = 5;
--
--
MySQL General Mailing List
For list archives
I want to , need to, have a way to check how many
records a user can insert into a table.
I thought it would be a, and maybe it is , a statement
using count(). Can count be used though if I want to
check by the user's ID ?
In other words, something like:
where ID = count() <= 5 , if ..
