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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MMNZ
  • Order by date
  1. MMNZ

    Tutorial on Regular Expressions?

    Hi, Can anyone suggest a good on-line source for information about MySQL Regular Expressions? I have an excellent book on MySQL, and it gives many examples, but it is not quite as comprehensive as I was hoping. The root of my problems start with values in a column that have a start value and...
    • MMNZ
    • Thread
    • Replies: 0
    • Forum: MySQL
  2. MMNZ

    DISTINCT list from two columns

    Thanks for the reply Tim, but it dosen't quite get me to where I need to be. Using: SELECT DISTINCT name1,name2 FROM test; As expected, I get two columns returned, one called "name1" showing all DISTINCT users, and one called "name2" showing all DISTINCT users. I am...
  3. MMNZ

    DISTINCT list from two columns

    I have a table named "test" with 4 columns: +------+------+------+------+ | num | info | name1 | name2 | +------+------+------+------+ And I want a DISTINCT list of the names from "name1" and "name2" (some of the same names may appear in either...
    • MMNZ
    • Thread
    • Replies: 5
    • Forum: MySQL
  4. MMNZ

    Sorting a Varchar Type Column with Numbers and Alpha

    I have two VARCHAR(20) columns that looks like this (in "DataTable", which contains many other columns): Scene_ID Shot_ID 1 10 2 2.1 2 2a 19 7 19 2.1 Test RevisionA...
    • MMNZ
    • Thread
    • Replies: 1
    • Forum: MySQL

Part and Inventory Search

Back
Top