How to search for images with specific START character in title?

[NetRebel]

Hi all,

I am building a UMD™ VIDEO database using 4images. Besides the standard search, I would like to search for all titles starting with a certain character. For instance, I would like to do a search for all titles starting with "B" and then it should provide a list like Bad Boys, Bad Santa, Barbershop etc. and NOT (like it does now) with the character B anywheren INSIDE the title.

Does anyone know if this is possible and if so, what URL should I use for this?

I want to create a line in my header like A | B | C | D | E ... etc which would enable the users to search the database in an alphabetic index order.

[V@no]

It will be a little difficult to do, because 4images doesn't search in titles or description itself, but searches in keywords.

[NetRebel]

Thank for your reply V@no. Perhaps I didn't ask the question the right way or I'm just misunderstanding you, but I'm pretty sure 4images DOES search the titles. Whatever name I give an image, 4 images will find it (using the quick search) when I enter a word that is in the name of the image. I'm not speaking of the actual FILEname of the image, but the name that is given and put in the SQL database when someone uploads an image.

[V@no]

The thing is, 4images splits image name, description, etc into separate words and stores these words as keywords.

[NetRebel]

Ah, okay. Starts to make sence now.

So basically 4images just doesn't "know" which word a title/name starts with but more sort of holds an index that "tells" it that a word, for instance "fast" appears in image 14, 70, 101, 250 etc. without 4images actually knowing how or where the word is in those images?
Guess the search function will be of no use then (like you already told me). I'll have to come up with some routine that just reads throug all the images or maybe create a hidden custom field for this.

Thanks again V@no, I'l' try some other approach.