skyshare's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
New Members
Active Posts:
5 (0.01 per day)
Joined:
27-November 12
Profile Views:
832
Last Active:
User is offline Nov 30 2012 10:46 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   skyshare has not set their status

Posts I've Made

  1. In Topic: Search whole table

    Posted 30 Nov 2012

    Thanks for the reply
  2. In Topic: Search whole table

    Posted 30 Nov 2012

    No, no other fields apart from the index
  3. In Topic: Search whole table

    Posted 30 Nov 2012

    The 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?

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

skyshare hasn't added any friends yet.

Comments

skyshare has no profile comments yet. Why not say hello?