Search found 95 matches
UNION
If I make a union on 2 tables works slower then making a single select on those 2 tables united?
- Fri Nov 25, 2005 7:26 am
- Forum: Databases
- Topic: sql search
- Replies: 2
- Views: 633
- Fri Nov 25, 2005 6:41 am
- Forum: Databases
- Topic: sql search
- Replies: 2
- Views: 633
sql search
I have a field in which the user enters some text.If the user enters Bulevard London it finds the results but if he enters London Bulevard it doesn't find anything because in the database I have Bulevard London(example) and not London Bulevard.How can I make an sql query that searches for the words ...
- Fri Nov 04, 2005 9:19 am
- Forum: Databases
- Topic: foreign key
- Replies: 3
- Views: 641
- Fri Nov 04, 2005 7:13 am
- Forum: Databases
- Topic: foreign key
- Replies: 3
- Views: 641
foreign key
I have ID in table1 and IDm in table2,ID is primary key in it's table.Is there anyway I can make a relation between those 2 keys so the compare between them works faster(foreign key or...)?
- Thu Nov 03, 2005 7:19 am
- Forum: Databases
- Topic: query help
- Replies: 2
- Views: 901
- Thu Nov 03, 2005 7:03 am
- Forum: Databases
- Topic: query help
- Replies: 2
- Views: 901
query help
I have in table "TEL" all telefones,names,adresses,City,Region ->many fields inserted in it I want to move distinct City and Region in another table "Region". can you help m with the select query? it should be something like this but don't work: insert into Region(City,Region) va...
- Mon Oct 31, 2005 9:31 am
- Forum: PHPDN Suggestions
- Topic: reputation
- Replies: 9
- Views: 8001
reputation
You could put a reputation on every user.This way if somebody is very satisfied of the answers he receives he can increase the reputation to the one that answered by one.