Help with a Database Query (I Think)

Discussion in 'Web Design and Development' started by mpw, Jan 4, 2006.

  1. mpw Guest

    Jun 18, 2004

    If I query the white pages website above it returns all the listings with the surname Williams.

    Is there any thing I can do to that address to return all the listings for Williams and for example Williamson and Williamstone etc.?

    The same source used to allow this but they changed the query screen so you had to visit their sponsor and now you have to put in the whole name exactly which screws me cause I can't spell.

    Thanks in advance.
  2. 4409723 Suspended


    Jun 22, 2001
    Just a stab in the dark:
    Not sure if either of those would work, but worth a try.
  3. sakasune macrumors member

    Mar 12, 2004
    It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).
  4. mpw thread starter Guest

    Jun 18, 2004
    Cheers tried both and neither do what I want although both do work at giving records with Williams just in different orders and Williams* gives one extra record.
  5. mpw thread starter Guest

    Jun 18, 2004
    Same again it works but displays the same info.

    Another thing the results are limited to 100 records. I see the 'Start=' but nowhere that would limit the number of records, any ideas?

    I also note that the error page I get states a full name is required for privacy reasons so that might just be that, fair enough.
  6. belvdr macrumors 603

    Aug 15, 2005
    No longer logging into MR
    This isn't SQL here. This is going straight to the web server code. They can hardcode the limit and how the query works, so you may have to deal with what they give you.

Share This Page