How to select the every first character from mysqli database:

Question

How to select the every first character from mysql database with different gallery name, i have that database - how to select the first image with galery name(column "gallery") img and the first image with gallery name img2?

http://prikachi.com/images/989/7212989B.png

enter image description here

I would not recommend saving an image in the database directly, but saving a link to the location of the image. — Mr. Radical, Mar 31 '14 at 14:49
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay — Mr. Radical, Mar 31 '14 at 17:19

score 0 · Accepted Answer · answered Mar 31 '14 at 14:44

0

You can use-

LIMIT 0,1

with your query, so that only 1 item (first item) is fetched.

For eg:

SELECT * FROM {table} WHERE gallery="img2" LIMIT 1

answered Mar 31 '14 at 14:44

Sahil Mittal

20,697
12
65
90

Could you make an example? – user3442381 Mar 31 '14 at 14:45

score 0 · Answer 2 · answered Mar 31 '14 at 15:08

If you want the first image in each gallery, then you have to GROUP BY the gallery column, and select the column you want, like:

SELECT gallery, min(id) from {table} GROUP BY gallery;

This will give you the output:

| gallery  |  id  |
+----------+------+
| img      |   1  |
| img2     |   2  |

How to select the every first character from mysqli database:

2 Answers2