Search query

[scialom]

Hello,

I am try to build a search engine to one of my application.

I want to have a search box that when one type 'a' you will see all the titles that start with 'a' and when one will add 'ad' he will see all the titles start with 'ad' and so on... I will use xmlhttprequest to do it, but I am not sure about the sql statement to use.

I know that 'select * from tbl_test where title '%a%' will bring me all the titles that has 'a' inside them. But I need only the titles that start with 'a'.

Any ideas?

Assaf

[drew010]

select * from tbl_test where title like 'a%'
will show all beginning with a