|
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
Navigation:
[Reply to this message]
|