2 Topics
|
|
|
|
I've been knocking my brains for a while with this one. I need to search a particular table for any records that contain an equal sign [B][COLOR="Red"]=[/COLOR][/B]. This works for any criteria except [B][COLOR="Red"]=[/COLOR][/B] : [CODE]SELECT id, mystuff FROM db1_user WHERE email LIKE '%=%'[/CODE]
|
|
|
I have a table with 15,00,000 rows which has a column PERMLINK which is used in 'where' clause of my select queries. To speed up query I have used it as INDEX. What size of index is optimum for names.? and I have a new idea but don't know how … |
The End.