search enquiry

[abyinsydney]

greetings fellow citizen
i'm designing a search engine where needs to thro a query such that the string entered in the text would return all matching records starting with it.


For instance if i enter david in a text field clause should return all the strings starting with david in the table like davids,davidjacobson

i reckon its with using wild cards does any one have the syntaxt for the same

query is

select * from table name where tablename.text= likeblaaw blaw

can one of you complete the query.or may be suggest me a site on sql

thanx in advance
aby

 

[venur]

Hi,

SQL Query:

select * from tablename where tablename.text like '%david%'

Cheers,
Venu