Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL field name iteration
- Thread starter Thomas001
- Start date
sleipnir214
Programmer
- Thread starter
- #4
Yes indeed, it is skewed. There isn't anything I can do about it however because the other programmer already has his code sorting it out this way but with Perl.
Basicly I'm trying to return the field name if the data within that column ='s the variable I set.
Basicly I'm trying to return the field name if the data within that column ='s the variable I set.
My first thought only sees a solution that uses SQL employing either an intricate 'OR' construct in the WHERE clause to limit to recors containing 'Joe' or a full-text index.
The second part then would be a while loop that iterates through the records - retrieved as associative array - and return the keys for fields where the value matches the search string.
The second part then would be a while loop that iterates through the records - retrieved as associative array - and return the keys for fields where the value matches the search string.
- Status