Re: FN-FORUM: MySQL

date posted 14th November 2007 11:44

You might be able to use 'Limit'

SELECT PictureTypeID, PictureTypeDescription FROM PictureType LIMIT 12

This will pull back the first 12 records, unless there are less than
12 in which case it will pull back all it can get.

Hal
--




On 14 Nov 2007, at 12:21, Lists - ARKAD Solutions wrote:

>
> Morning all,
>
> Blonde day at the moment and I can't think of how to do this....
>
> How do I do select statement to get a specified number of records
> from a
> table.
>
> What I have so far is...
>
> SELECT PictureTypeID, PictureTypeDescription FROM PictureType
>
> I have a list of PictureTypeID Values...which is what I want to
> select..
>
> TIA
>
> Darren
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>