Selecting only certain data

Hi, how do I make it so only data with the type column as pictures will be displayed.

In the column 'type' there can either be; Picture, Video, Music or Flash
I only want the rows that contain 'Picture' in the type column to be displayed.

$sql = "SELECT * FROM portal ORDER BY type LIMIT 20";

Thanks :)

Hi, how do I make it so only data with the type column as pictures will be displayed.

In the column 'type' there can either be; Picture, Video, Music or Flash
I only want the rows that contain 'Picture' in the type column to be displayed.

$sql = "SELECT * FROM portal ORDER BY type LIMIT 20";

Thanks :)

$sql = "SELECT * FROM portal where type = 'Picture' ORDER BY type LIMIT 20";

best regards

$sql = "SELECT * FROM portal where type = 'Picture' ORDER BY type LIMIT 20";

best regards

Thanks :D