|
|
|
|
Joined: Jul 1999
Posts: 118
Enthusiast
|
|
Enthusiast
Joined: Jul 1999
Posts: 118 |
I need a database command to find all posters from a certain ip number are wildcards possible? like 215.224.4.* ?? or just all starting with 214.224.4. Thanks!!!! 
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
In MySQL, _ matches any single character, and % matches any string.
SELECT U_Username,U_RegIP
FROM w3t_Users
WHERE U_RegIP LIKE '215.224.4.%'
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 254
Joined: January 2000
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
