DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- MySQL (http://www.daniweb.com/forums/forum126.html)

- - suggest query (http://www.daniweb.com/forums/thread158732.html)

praveen_dusari

Nov 21st, 2008 3:33 am

suggest query

hi all,
i have a auto suggestion box which displays countries when we type a it will display all countries starting with letter a like alaska,australia etc...,but i want to display every name which has letter a in names like australia,india,
etc...

pritaeas

Nov 21st, 2008 7:31 am

Re: suggest query

SELECT * FROM countries WHERE country LIKE '%a%'

varmadba

Dec 1st, 2008 5:44 am

Re: suggest query

If there are small number of rows in a table u can go with Like '%a%'
else you need to try full text index

All times are GMT -4. The time now is 5:12 pm.