Posted by Stefan Rybacki on 09/05/05 11:24

RootShell wrote:
> select * from tbl_person where name like '%Jimm%'
>
> That way all Jimm's will appear even "John Jimmy" ;)
>
Yes and no index will be used, very good! ;)
And "Johnjimm" will also be found. However, I just said was to keep performance even on
big tables you could use a fulltext index if you also want to search for lastnames.

Stefan

[Back to original message]