how to search only letters and numbers in tables

Codes here !

Moderators: egami, macek, gesf

Post Reply
New php-forum User
New php-forum User
Posts: 47
Joined: Sat Nov 18, 2006 7:32 am

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.

Post Reply