php code for searching data alphabetically from MySQL database

[bethifUL13]

Hi, I am currently developing a website for our school project that is connected to the mySQL database. I am now creating a search page that will display the title of research papers stored in the database.
When I click the letter 'A', it should display all the titles starting in letter 'A' that is stored in the database. What is the right code for that? thanks in advance.
:D

[Rabbit]

You can use the LIKE operator with the appropriate WILDCARD in your SQL.

[bethifUL13]

thanks .. i'll try it

[bethifUL13]

can you give sample code for that? tnx :)

[mansour indinga]

give me some sample of program

[mansour indinga]

can you give an sample about library borrowing system using MSAccess

[Rabbit]

SELECT *
FROM someTable
WHERE someField LIKE 'The%'