Reputation: 0 Apprentice
- New Members
- Active Posts:
- 5 (0.03 per day)
- 27-November 12
- Profile Views:
- Last Active:
- Nov 30 2012 10:46 AM
- Dream Kudos:
Posts I've Made
Posted 30 Nov 2012Thanks for the reply
Posted 30 Nov 2012No, no other fields apart from the index
Posted 30 Nov 2012The fields are text fields named 'PR1' to 'PR20' which hold a string of text less than 10 characters. Not all are populated but there are thousands of rows. The text I want to search for could be anywhere in the table.
So the current sql I use would be :
'select * from mytable where PR1 = 'mytext' or PR2 = 'mytext' or pr3 = 'mytext' ....etc
I just wondered if there was a way to search the whole table at once?
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
skyshare hasn't added any friends yet.