Re: FN-FORUM: MySQL

date posted 14th November 2007 11:37

On Wed, 2007-11-14 at 12:21 +0000, 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

SELECT PictureTypeID, PictureTypeDescription FROM PictureType limit 10;

(limit is mysql-specific, though).

Graham

>
> I have a list of PictureTypeID Values...which is what I want to select..
>
> TIA
>
> Darren
>
>
>