[igotregistered]

I'm creating a module for my cmps which will be alphabetical search links to my vbtube page, abcdefg..........

How can I do a search in the tube by letter? If I type "A" and click search I get every single tube because the search is pulling everything with an "A" in it. I just want the very first letter of any title.

Possible?

[s7v7n]

Now we are using this one:
vbtube_tubes.title LIKE '%$searchtext%'

This one would search everything with a starting a.
vbtube_tubes.title LIKE 'a%'

You can do some edits at vbtube_search.php. It´s not a hard job to make a alphabetical Search... You can look at the codes i used you can edit them...

[igotregistered]

Hmmm, I tried entering a% into the search and it still winds up pulling any title that has an "A" anywhere in the title. Not as the first character.