Dr. Who needs assistance

[AndyGroom]

Is there a way to phrase a MySQL query so that if the user searches for "dr who" it will find a match for "dr. who" and vice-versa?

- Andy
___________________________________________________________________
If a man speaks in a forest and there are no women around to hear him - will he still be wrong?

 

[r937]

it would take some fancy footwork using your application language to parse the words in the search string

for instance,

WHERE somecolumn LIKE '%dr%who%'

will find 'dr. who'

but you have to write a reasonably smart parser, and that's not really a mysql issue

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[majlumbo]

You may want to look at using the MySQL's string regular expression operator:

http://dev.mysql.com/doc/refman/5.1/en/regexp.html

 

[feherke]

Hi

For just one character [tt]replace()[/tt] may be more efficient :

[b]where[/b] replace[teal]([/teal]somecolumn[teal],[/teal][green][i]'.'[/i][/green][teal],[/teal][green][i]''[/i][/green][teal])=[/teal]replace[teal]([/teal][green][i]'dr. who'[/i][/green][teal],[/teal][green][i]'.'[/i][/green][teal],[/teal][green][i]''[/i][/green][teal])[/teal]

Feherke.

 

[AndyGroom]

Thanks for the ideas!

- Andy
___________________________________________________________________
If a man speaks in a forest and there are no women around to hear him - will he still be wrong?