Search:

Type: Posts; User: james438; Keyword(s):

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    17,404

    Ah, thank you. I do have very small tables, but...

    Ah, thank you. I do have very small tables, but as tables grow I want to be sure that the search queries that I have will search them in the most efficient way. The cols contain fields that can be...
  2. Replies
    5
    Views
    17,404

    cool, thanks. That actually will allow me to...

    cool, thanks. That actually will allow me to write far smaller queries with the use of arrays to make queries that are maybe 100 characters long as opposed to 2000 or so.

    What I was thinking was...
  3. Replies
    5
    Views
    17,404

    "select * " vs "select col1, col2 "

    Two questions. Which is faster? select * from table1 where (col1 like term) and (col2 like term).

    or is this faster:

    select col1, col2 from table1 where (col1 like term) and (col 2 like...
Results 1 to 3 of 3