|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
April 8th, 2000, 01:52 AM
|
|||
|
|||
|
how do you search multiple tables? i have 3 tables and i want to search for a certain name, and the name may be in either of the 3 tables, i also want to return similiar names as the one being looked for. That is, if someone looks for tom then it will look in all three tables returning the results for tom, tommy, tom1, tom2, etc.
thanks in advance...
|
|
#2
April 8th, 2000, 07:53 AM
|
|||
|
|||
|
You'll have to query each table seperately.
As far as searching for a column that would contain all variations: select * from tbl_name where clmn_name LIKE '%$search_term%' This will return records that contain the search term in clmn_name at any location. '$search_term%' will return if the search term STARTS the field. HTH
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > table searching |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
