Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

how to search only letters and numbers in tables

Codes here !

Moderators: macek, egami, gesf

how to search only letters and numbers in tables

Postby Jason_C » Sat Mar 22, 2014 11:04 am

I wish to know how google does their search, say there is a road called St. John's Road in my database and I type in my ajax-auto-sugestion field...

St John

How can I get the auto-selection to show the road that is LIKE the content but do not use the . or the ' in the database

If I was to start to type...

St. John

then it would of course show the suggestion as I used the .

Can this be done ?

My fields have the proper names of the roads and I use utf8_general_ci for the road name field and the LIKE method to get the results.
New php-forum User
New php-forum User
Posts: 29
Joined: Sat Nov 18, 2006 7:32 am

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.